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

mukhilpadmanabhan profile image

A Simple Guide to Docker Compose & Multi-Container Applications

Mukhil Padmanabhan -

meghasharmaaaa profile image

Docker Commands - Part 1

Megha Sharma -

sarwarasik profile image

MongooseServerSelectionError: 🚨Server selection timed out after 30000 ms

Sarwar Hossain -

blacknight318 profile image

Self-Host a Joplin Sync Server in Proxmox

Blacknight318 -