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

snyk_sec profile image

Vulnerability: runc process.cwd and leaked fds container breakout (CVE-2024-21626)

SnykSec -

cmcrawford2 profile image

BigQuery Machine Learning

Cris Crawford -

abhikbanerjee99 profile image

Password-less Login in Go from Scratch

Abhik Banerjee -

aminnairi profile image

Isomorphic deployments using Docker Contexts

Amin -