I'm trying to create a Bash script based on variables. It works well when I'm using bash command line via docker image: #docker exec app_mysql mysqldump --login-path=localroot masterdb | gzip > 1111111.sql.gz While I'm trying to reproduce the same via…
in phpMyAdmin I can see all databases and tables. But when clicking on any table I get the error Error #1932 - Table 'mytablename' doesn't exist in engine I tried a lot of solution advises found on Google and Stackoverflow,…
I have two tables involved in this situation: tools_events COLUMN_NAME DATA_TYPE event_id int event_type varchar event_value varchar event_client int event_timestamp datetime tools_clients COLUMN_NAME DATA_TYPE client_id int client_name varchar client_developer int This is using MySQL 5.6. The events table obviously stores…
I have an invoicing system that runs off an sql db. Every time I create a new invoice, the invoice number increases by 1. So invoice number 5000, the next is 5001, then 5002 and so on. I want so…
it has been a long day and i don't know why i am stuck at this problem for such a long time so any help is very much appreciated! my problem is the famus code: 'ECONNREFUSED' which suddenly appeared for…
condition was removed compose spec in versions 3.0 to 3.8 but is now back! Using version of the compose spec v3.9, you can use condition as an option in long syntax form of depends_on. I use docker compose to start…
I am trying to run spring boot and mysql through docker, but there is a problem that I cannot connect. docker-compose.yml version: "3.7" services: docker-mysql: container_name: docker-mysql image: mysql:8.0.28 environment: MYSQL_USER: user MYSQL_PASSWORD: 1234 MYSQL_ROOT_PASSWORD: 1234 ports: - "3306:3306" networks:…
I need a query that returns order IDs that has mentioned in the comments certain word. I have three separate queries I want to merge then into one. So the result will be that I'll get orders IDs only after…
I have recently installed docker-compose on Ubuntu. I can connect to my local host, phpmyadmin and stuff. However, when I try to connect to it with mysqli_connect, I can reach the server but I cannot access it with Warning: mysqli_connect():…
10 million rows. Want to backup data in SQL files with 100k rows (breaking the data into chunks). Is it possible to run a query like this: SELECT * FROM `myTable` WHERE `counter` > 200000 and `counter` <= 300000 --->…