# backup
docker exec -it container mysqldump -u**** -p*** --all-databases > mysql_dump_yyyy_mm_dd.sql

# restore
cat backup.sql | docker exec -it container mysql -u**** -p**** --all-databases