Backup / restore SQL DB

mysql backup

docker exec {CONTAINER} /usr/bin/mysqldump -u {USER} --password={PASSWORD} {DATABASE} > {BACKUP_FILE_PATH}

# For ignoring some tables
docker exec {CONTAINER} /usr/bin/mysqldump -u {USER} --password={PASSWORD} --ignore-table={DATABASE}.{TABLE} {DATABASE} > {BACKUP_FILE_PATH}

mysql restore

cat {BACKUP_FILE_PATH} | docker exec -i {CONTAINER} /usr/bin/mysql -u {USER} --password={PASSWORD} {DATABASE}

postgres backup

docker exec -it ${DB_CONTAINER} bash                                    # create a new Bash session in the container
pg_dumpall -c -U ${DB_USER} > ${FILENAME}                               # dump sql data
docker cp ${DB_CONTAINER}:${FILENAME} ./${DESTIONATION_PATH}            # copying dumped data from container to host

postgres restore

docker cp ${DUMPED_FILE_PATH} ${DB_CONTAINER}:.             # copying dumped data from host to container
docker exec -it ${DB_CONTAINER} bash                        # create a new Bash session in the container
psql -U ${DB_USER} ${DB_NAME} < ${FILENAME}                 # restore sql data