PicInch Gallery provides a simple way for a group of members, such as a photography club, to display their photographs.
PicInch uses the following files and directories, under
certsLet’s Encrypt certificates. Backup not required.
geodbGeo database. Backup not required.
miscServes files placed there. Backup the originals.
mysqlThe live database. Not suitable for backup.
photosUsers’s photos. Backup required.
siteSite configuration. Backup whenever changes are made.
docker-compose.ymlBackup whenever changes are made (or keep parameters in
There is no inbuilt support for backups. Some VM hosts offer a periodic backup of the whole server.
For a manual backup:
docker exec picinch_db /usr/bin/mysqldump -uroot -<root-password> picinch > backup.sql
/srv/picinch/photosto the backup system.
To restore from backup:
docker exec -i picinch_db /usr/bin/mysql -u root -<root-password> picinch < backup.sql