docker.md

Docker

Pgsql

Backup

docker exec -t $(docker-compose ps -q pgsql) pg_dumpall -c -U oro_db_user > dump.psql

Restore

cat dump.psql | docker exec -i $(docker-compose ps -q pgsql) psql -U oro_db_user -d oro_db

MYSQL

Backup

docker exec $(docker-compose ps -q mysql) mysqldump --no-tablespaces -u oro_db_user --password=oro_db_pass oro_db > backup.sql

Restore

cat backup.sql | docker exec -i $(docker-compose ps -q mysql) mysql  -u oro_db_user --password=oro_db_pass oro_db