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

mysql backup

docker exec -t {CONTAINER} mysqldump -u {USER} --password={PASSWORD}  {DATABASE} > {BACKUP_FILE_PATH}
docker exec -t db mysqldump -u root --password=yelobank  YeloBankProjectDB > _backups/data.sql

mysql restore

cat {BACKUP_FILE_PATH} | docker exec -i {CONTAINER} /usr/bin/mysql -u {USER} --password={PASSWORD} {DATABASE}
cat _backups/data.sql | docker exec -i db /usr/bin/mysql -u root --password=yelobank YeloBankProjectDB

postgres backup

docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

postgres restore

cat your_dump.sql | docker exec -i your-db-container psql -U postgres