HowTo backup restore geokrety db

Jump to bottom

Vandeputte Brice edited this page Sep 2, 2019 · 2 revisions

how to backup / restore geokrety db

docs gist

for windows gkShell users

create a backup

winpty docker exec -ti geokrety_db bash
/usr/bin/mysqldump -u root --password=mypassword geokrety-db > 2019_09_03_backup.sql
docker cp geokrety_db:/2019_09_03_backup.sql .

restore a backup

docker cp ./2019_09_03_backup.sql geokrety_db:/
winpty docker exec -ti geokrety_db bash
echo "CREATE DATABASE  IF NOT EXISTS geokrety_restored; USE geokrety_restored;" | /usr/bin/mysql -u root --password=mypassword
cat 2019_09_03_backup.sql | /usr/bin/mysql -u root --password=mypassword geokrety_restored