# nextcloud migration

Set system into maintenace mode
```bash
docker-compose exec --user www-data app php -d memory_limit=2048M occ maintenance:mode --on
```
Backup DB
```bash
docker exec db mysqldump --single-transaction -h localhost -u root -p[password] nextcloud > nextcloud-sqlbkp_`date +"%Y%m%d"`.bak
```
Sync folders
```bash
rsync -Aavx data -e ssh bodo@super71.home:/var/lib/docker/data/
```
```bash
rsync -Aavx custom_apps -e ssh bodo@super71.home:/var/lib/docker/data/
```
```bash
rsync -Aavx themes -e ssh bodo@super71.home:/var/lib/docker/data/
```
```bash
rsync -Aavx config -e ssh bodo@super71.home:/var/lib/docker/data/
```
Drop DB
```bash
docker exec mariadb mysql -h localhost -u root -p[password] -e "DROP DATABASE nextcloud"
```
```bash
docker exec mariadb mysql -h localhost -u root -p[password] -e "CREATE DATABASE nextcloud"
```
Restore DB
```bash
cat nextcloud-sqlbkp_20201110.bak | docker exec -i mariadb /usr/bin/mysql -u root --password=[password] nextcloud
```
Restore Files
```bash
rsync -Aax /var/lib/docker/data/data/ /var/lib/docker/volumes/docker_nextcloud-data/_data/
```
```bash
rsync -Aax /var/lib/docker/data/custom_apps/ /var/lib/docker/volumes/docker_nextcloud-custom_apps/_data/
```
```bash
rsync -Aax /var/lib/docker/data/themes/ /var/lib/docker/volumes/docker_nextcloud-config/_data/www/nextcloud/themes/
```


Set rights
```bash
docker-compose exec nextcloud chown -R 1002:1002 /config
```
```bash
docker-compose exec nextcloud chown -R 1002:1002 /data
```
```bash
docker-compose exec nextcloud chown -R 1002:1002 /config/www/nextcloud/custom_apps
```

```bash
docker-compose exec nextcloud updater.phar
```

```bash
docker-compose exec nextcloud occ maintenance:mode --on
```

```bash
docker-compose exec nextcloud find /data/ -type d -exec chmod 750 {} \;
```
```bash
docker-compose exec nextcloud find /data/ -type f -exec chmod 640 {} \;
```
```bash
docker-compose exec nextcloud occ files:scan --all
```
```bash
docker-compose exec nextcloud occ maintenance:repair
```
```bash
docker-compose exec nextcloud occ db:add-missing-indices
```
```bash
docker-compose exec nextcloud occ db:convert-filecache-bigint
```
```bash
docker-compose exec nextcloud occ background-job:execute OCA\Recognize\BackgroundJobs\ClassifyImagenetJob
```
```bash
docker-compose exec documentserver /var/www/onlyoffice/documentserver/npm/json -f /etc/onlyoffice/documentserver/local.json 'services.CoAuthoring.secret.session.string'
```