Import and Export MySQL and PostgreSQL databases inside Docker containers

by | Sep 26, 2022 | Database

I need to dump databases just infrequently enought that I have not memorized the correct commands yet.

PostgreSQL

Export

docker exec -t DB_CONTAINER_NAME pg_dumpall -c -U postgres > dump.sql

Import

cat dump.sql | docker exec -i DB_CONTAINER_NAME psql -U postgres

MySQL

Export

docker exec DB_CONTAINER_NAME /usr/bin/mysqldump -u root --password=PASSWORD DATABASE > backup.sql

Import

cat backup.sql | docker exec -i DB_CONTAINER_NAME /usr/bin/mysql -u root --password=PASSWORD DATABASE