Files
Skripte/Sicherung und Restore von mysql-DBs aus Docker.txt

11 lines
409 B
Plaintext

# Backup
# docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql
sudo docker exec 4G-db-1 /usr/bin/mysqldump -u root --password=root ca_system > ca_system_backup.sql
# Restore
# cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE
cat ca_system_backup.sql | sudo docker exec -i 4G-db-1 /usr/bin/mysql -u root --password=root ca_system