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.