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
@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

@cesarinobruno
Copy link

Thanks!

@lnfel
Copy link

lnfel commented Mar 9, 2023

Still works in 2023!

@maksam07
Copy link

Still works in 2023!

I have this page in my bookmarks. I hope it stays up forever and never gets deleted

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