How to stream a MySQL DB Dump from Docker

Question

A docker container made a huge crawl and now the disk space from the VM is almost full. So, I need a solution to export the sql data without exceeding the disk space.

I already found a solution how I can create a MySQL dump in docker but in this post you would create a sql file which could be too big.

I am connected to the VM via ssh and can use the docker-cli. Do you know any solutions how I could kind of stream the data to my PC?

Just an idea... I had seen a trick for this, on how to transfer a file by using netcat. Check the "send file" part of this photo by Julia Evans. — tgogos
– tgogos, Commented Oct 6, 2020 at 8:15
can't you provide a network path as the target for the dump? — Shadow
– Shadow, Commented Oct 6, 2020 at 9:29

lain0 · Accepted Answer · 2022-02-15 12:41:33Z

1

With docker: i have 2 projects deployed via docker-compose docker ps shows 2 mysql containers running: proj1-mysql-1 proj2-mysql-1 so i can directly:

docker exec -it proj1-mysql-1 mysqldump db_development |docker exec -i proj2-mysql-1 mysql db_development

With ssh you can do the same but run mysql via ssh

answered Feb 15, 2022 at 12:41

lain0

1273 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to stream a MySQL DB Dump from Docker

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related