Backup and restore data from a running mysql docker container

backup.sh

# 1. start the db container and map it to local port 3306
# 2. dump it (remove --no-create-info to also migrate schema)
$ mysqldump --port 3306 -h 0.0.0.0 -prootpw --no-create-info database > mydb.sql
# 3. move to another host
$ scp source:~/mydb.sql dest:~/
# 4. start db on destination
# 5. create schema if not created automatically
# 6. restore data
$ mysql --port 3306 -h 0.0.0.0 -prootpw database < mydb.sql