Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Backup and restore a mysql database from a running Docker mysql container
# 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
@Tipset
Copy link

Tipset commented Aug 17, 2022

This helped a bunch, thank you!

@hkanizawa
Copy link

Thanks

@tomaszroot
Copy link

:-*

@botosdavid
Copy link

thank you so much!

@dorimusz
Copy link

Thanks a lot!

@ttcosta11
Copy link

Thank you!

@tgiovanella87
Copy link

Great! Thanks!

@paulovnas
Copy link

Very nice... Thank you so much.

@samplec0de
Copy link

Exactly what I looking for, thanks!

@nnearobot
Copy link

Exactly what I needed. Thank you so much!

@sukruaydinlik
Copy link

Thank you so much. Restore command worked like a charm. Unbelieveable to see that instructions on official Docker image page fail.

@razavistag
Copy link

this works thank you

@meng7171
Copy link

meng7171 commented Jan 8, 2023

good, bro. THANKS.

@paulograbin
Copy link

This is awesome, thank you!

@canuk99
Copy link

canuk99 commented Jan 26, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment