September 14, 2020 - Patrick Kerwood
This is just two simple commands to backup and restore an active MySQL/MariaDB database running in a container.
So basically, below command just a
mysqldump command, but it saves the dump file on the host instead of in the container. I use these commands maybe more often than I'd like to admit, when backing up a private hosted SQL database.
Again, I post these two commands because og my own deteriorating memory.
docker exec -i [mysql_container_name] mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
docker exec -i [mysql_container_name] mysql -u root -p[root_password] [database_name] < dumpfilename.sql