Expose the mysql database about docker-xampp HOT 3 CLOSED

I managed to do it using volumes.

The idea is to first create a volume via

docker volume create my_volume

Then mount the volume when running the container in a similar way as it's done with bind, except you indicate the volume type:

docker run --name xamppContainer -p 41061:22 -p 41062:80 -d --mount type=volume,source=my_volume,target=/opt/lampp/var/mysql -v ~/path/to/apache_conf:/opt/lampp/apache2/conf.d -v ~/path/to/www:/www xamppImage:latest

You can inspect the volume via docker volume inspect my_volume to find the path where the volume data is stored.

To save the MyISAM table folders and InnoDB blocks, I set the volume target (in the mount option) to /opt/lampp/var/mysql. The volume driver will populate the volume if the container has files at the target location, which is the case. The volume will keep the persistent data and can be shared with other containers.

See @tomsik68 's link suggestion https://docs.docker.com/storage/volumes/ to find more information regarding volumes.

Note: I'm using podman instead of docker, but the solution is the same.

from docker-xampp.

Hello, I'm sorry to hear you lost your database. This container is really intended just for development purposes where the database doesn't need to be preserved.

I believe you need to use Docker volumes to persist data between container migrations. Sorry to say that I don't know how to do that myself. Please refer to the Docker volume reference to find out more.

from docker-xampp.

Thank you for sharing the solution!

from docker-xampp.