Docker MySQL dump

Trick Of The Day: Copy DB dump from one Docker container to another

Apr 23, 2019
1 minutes read
0 Comments

How to copy MySQL dump from one Docker container to another ?

Situation

You need to create DB dump in one Docker container and apply it in another Docker container.

Application

Crate DB dump on staging env and apply it on local env to experiment with existing database.

Solution

Connect to first container:

$ docker exec -ti mysql-staging /bin/bash

Create DB dump:

$ mysqldump -u user -p --databases db > /tmp/db.sql

Copy dump to localhost:

# general syntax:
# docker cp CONTAINER:SRC_PATH DEST_PATH
$ docker cp mysql:/tmp/db.sql /tmp/db.sql

Copy dump to second container:

# general syntax:
# docker cp DEST_PATH CONTAINER:SRC_PATH
$ docker cp /tmp/db.sql mysql:/tmp/db.sql

Apply DB dump:

$ docker exec -ti mysql /bin/bash
$ mysql -u user -p
-- Run the backup script to recreate the database
mysql> drop database if exists db;
mysql> source /tmp/db.sql