Skip to content

Instantly share code, notes, and snippets.

@spalladino
Created December 22, 2015 13:47
Show Gist options
  • Save spalladino/6d981f7b33f6e0afe6bb to your computer and use it in GitHub Desktop.
Save spalladino/6d981f7b33f6e0afe6bb to your computer and use it in GitHub Desktop.
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
@maksam07
Copy link

sudo docker

sudo docker?

@muzzammil194
Copy link

sudo docker

sudo docker?

if docker does not add in a group of Linux so it does not execute with full permission

@carlosjuanco
Copy link

Gracias por el script de respaldo @muzzammil194

@icanitam
Copy link

icanitam commented Oct 2, 2023

thanks a lot! still work

@saidbakr
Copy link

You should get Nobel prize for these two lines of code!

@wac-max
Copy link

wac-max commented Feb 9, 2024

Works perfectly. thank you!

@dangduytung
Copy link

It works, thanks.

@rajat3604
Copy link

It works, for me. Thanks

@ricardogranafirst
Copy link

Thanks!

@mehrabcz
Copy link

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

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