How to migrate MySQL data directory in docker container? How to migrate MySQL data directory in docker container? docker docker

How to migrate MySQL data directory in docker container?


You could start MySQL using the 5.5 image and run mysqldump against it

docker run --rm --link mysqld mysql:5.5 \       mysqldump -h mysqld --all-databases > /your/host/machine/

And then start a new container using the 5.6 image and initialize it using the SQL dump

docker run -v /data/your_dump.sql:/docker-entrypoint-initdb.d/dump.sql mysql:5.6


I believe you need to modify your dockerfile to run mysql-upgrade before starting mysql. Although you might need to repair it as well as described in the references you provided. You should only need to run it once, then you can remove it from dockerfile. (I assume database is actually stored on the host file system and mounted in the docker.)