I'm developing an API with Flask and I cannot retrieve queries from a MySQL database I've connected with flask-sqlalchemy (not sqlalchemy alone). This is a pre-existing database downloaded from my client's PHPMyAdmin, so I haven't ran db.create_all(): I simply created…
My database won't start after restarting the server. it throws the following error; [ERROR] InnoDB: Page [page id: space=1106, page number=4119] log sequence number 29970252505 is in the future! Current system log sequence number 29967893604. [ERROR] InnoDB: Your database may…
I stumbled across a problem with docker volumes while starting docker containers with a docker compose file (MariaDB, RabbitMQ, Maven). I start them simply with docker-compose up -d (WITHOUT SUDO) My volumes are definied like this: ... volumes: - ./production/mysql:/var/lib/mysql:z…
I want to insert given values from my docker app-service to the MariaDB-service. The connection has been established because I can execute SELECT * FROM via the MariaDB.connection.cursor. First of all I create the connection: def get_conn() -> mariadb.connection: try:…
I am trying to make an image that uses the MySQL image as its base and I want to create a database (and some other stuff) once I know the server is up. I have a bootstrap script as my…
I am getting the following error on a website. I create ticket for this reason in my hosting provider. It told me "You need to edit the select query, not a select query suitable for the mariadb version on the…
I'm having problems with docker-compose for a while now and can't figure out what's going on there. Given is the following scenario - which worked before but stopped working on a new project and now on every new stack I…
I've read a post saying that I would have to use this command below, to dump my sql files $ mysqldump -u [uname] -p db_name > db_backup.sql However, my question is, I don't quite get where the db_backup.sql comes from.…
I'm using this query to remove duplicates from phoenix_tasks table: CREATE TEMPORARY TABLE temp SELECT `piva` FROM phoenix_tasks GROUP BY `piva` HAVING COUNT(*) > 1; DELETE FROM phoenix_tasks WHERE `piva` IN (SELECT `piva` FROM temp) AND taskStateId=1 ; DROP TEMPORARY…
I have a dockercompose with MariaDB+PHPMyadmin. I'm running some commands inside db service but after them it ends with code 0 while i'm expecting a mariadb server running. I checked my docker-compose.yml without commands and it worked fine. This is…