# 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 | |
good, bro. THANKS.
This is awesome, thank you!
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
Thanks!
Still works in 2023!
this works thank you