Backup and restore a mysql database from a running Docker mysql container

mysql-docker.sh

# 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

sudo docker

sudo docker?

sudo docker

sudo docker?

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

Gracias por el script de respaldo @muzzammil194

thanks a lot! still work

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.