DEV Community

Reishi Mitani
Reishi Mitani

Posted on

SQL Dump in Docker

#sql #docker

First, enter your mysql docker container.

// in your local machine
$  docker exec -it up_mysql_1 /bin/bash
Enter fullscreen mode Exit fullscreen mode

Dump your file.

# mysqldump -u root -p DB_NAME > outputfile.sql
Enter fullscreen mode Exit fullscreen mode

The file will be dumped in your docker container.
Transport the file to your local machine using the following command.

// in your local machine
$ docker cp CONTAINER_ID:/outputfile.sql ~/Documents/outputfile.sql
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

ptuladhar3 profile image

Avoid Using “bloated” Node.js Docker Image in Production!

Puru -

i_am_vesh profile image

How to Increase Efficiency of Dockerfiles-Docker Day 1.5

Avesh -

prahladyeri profile image

Unlocking speed: the power of indexing in database performance

Prahlad Yeri -

tusharops_29 profile image

Docker Networking – Basics, Network Types & Examples

Tushar Gayakwad -