Backup and restore a mysql database from a running Docker mysql container

mysql-docker.sh

# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

pv $BACKUP | docker exec -i $CONTAINER /usr/bin/mysql -u $MARIA_DB_USER --password=$MARIA_DB_PASS $MARIA_DB_NAME


## PORTGRESS

# Backup
docker exec -t CONTAINER pg_dump --schema-only -U postgres > structure.sql

## Only structure or with exclued table data

docker exec -t docker_postgres pg_dump --schema-only -U postgres > structure.sql

docker exec -t docker_postgres pg_dump postgres --exclude-table-data='public.sites_acessos' --exclude-table-data='public.views_e_cliques' --exclude-table-data='public.movimentacoes' -U postgres > bck.sql


###

docker exec -i postgress_dev_upee /bin/bash -c "PGPASSWORD=upeetest2020 pg_dump --username postgres postgres" > backup.sql

# Restore
cat your_dump.sql | docker exec -i CONTAINER psql -U postgres