What if you are running docker version of own cloud server based on https://doc.owncloud.com/server/10.8/admin_manual/installation/docker/ and you need to restore db content from backup?
I found nothing while searching for it – so I had to find it out by myself.
I did as follows:
- stop all owncloud services:
docker-compose down
- remove MariaDB whole content:
rm -rf /share/Container/container-station-data/lib/docker/volumes/owncloud-server_mysql/_data/*
- start db service alone:
docker-compose up -d db
- exec bash in db service:
docker-compose exec db bash
- restore db:
zcat /var/lib/backup/backup.1/owncloud.sql.gz | mysql db -u dbuser -p; exit
stop db service: docker-compose down
- start all services:
docker-compose up -d
- follow owncloud db restore process:
docker-compose exec own cloud occ maintenance:mode --on; docker-compose exec own cloud occ maintenance:data-fingerprint; docker-compose exec own cloud occ maintenance:mode --off
That’s all folks! I hope it will help someone.