-
Star
(2,550)
You must be signed in to star a gist -
Fork
(617)
You must be signed in to fork a gist
-
-
Save spalladino/6d981f7b33f6e0afe6bb to your computer and use it in GitHub Desktop.
| # 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 | |
You should get Nobel prize for these two lines of code!
Works perfectly. thank you!
It works, thanks.
It works, for me. Thanks
Thanks!
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
thanks a lot! still work