Backup and restore a mysql database from a running Docker mysql container

mysql-docker.sh

# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

I've visited this link countless times! Thank you for providing such a helpful sample.

beautiful piece of code

Perfect!

good one @muzzammil194

thanks buddy!

But not working for docker compose because it uses TTY by default. Version for compose:
cat backup.sql | docker compose exec -T SERVICE mysql -u root --password=root DATABASE

Anybody figure out this socket issue? docker exec zabbix-docker-62_zabbix-server_1 /usr/bin/mysqldump -u root --password=secret -S /var/run/mysqd/mysqld.socket zabbix > ~/zabbix.dump

mysqldump: Got error: 2002: "Can't connect to local server through socket '/var/run/mysqd/mysqld.socket' (2)" when trying to connect "Can't connect to local server through socket '/var/run/mysqd/"Can't connect to local server through socket '/var/run/mysqd/mysqld.socket' (2)" when trying to connect

mysqld.socket' (2)" when trying to connect

mysql> show variables like 'socket'; +---------------+-----------------------------+ | Variable_name | Value | +---------------+-----------------------------+ | socket | /var/run/mysqld/mysqld.sock | +---------------+-----------------------------+ 1 row in set (0.01 sec)

mysql> quit Bye

bash-4.4# ls -l /var/run/mysqld total 12 -rw-r----- 1 mysql mysql 2 Jan 24 20:28 mysqld.pid srwxrwxrwx 1 mysql mysql 0 Jan 24 20:28 mysqld.sock -rw------- 1 mysql mysql 2 Jan 24 20:28 mysqld.sock.lock srwxrwxrwx 1 mysql mysql 0 Jan 24 20:28 mysqlx.sock

Someone figured this out ?

✅ Correct command:

docker exec zabbix-docker-62_zabbix-server_1 /usr/bin/mysqldump -u root --password=secret -S /var/run/mysqld/mysqld.sock zabbix > ~/zabbix.dump

@arLevi