Q How do I restore a PaperCut database file?
PaperCut (Internal Database):
The PaperCut data (stored in the internal database) can be restored either by restoring the contents of the directory:
from your latest off-disk backup (e.g. your backup software). Remember to stop the PaperCut Application Server service before restoring (so the files are not in use at the time of restoration).
Or, alternatively (a secondary option), PaperCut has an inbuilt database export feature at the application-level which is a form of backup. It is possible to restore a point-in-time export file created by PaperCut. These are stored in the directory:
Again, you may need to restore your latest point-in-time database export file from your system’s off-disk backup system. The files all end in a zip extension and are named with the date and time allowing you to select the most recent export. Database exports can be imported into the system using the
db-tools program as detailed in the user guide here:
PaperCut (External Database):
All data is stored in the external database with the exception of:
- The Print Archive data (see below)
- The admin password (for security reasons)
- The database connection details
Instead, these settings are stored in the ~/server/server.properties file. If the Application Server fails, all data is still safe in the external database. Simply re-installing PaperCut, complete the configuration wizard, then pointing it to the existing external database will restore all settings and data.
If your database crashes, follow your database’s recommended restore procedure. Again, PaperCut does maintain it’s own point-in-time database exports (see above) in the directory:
Q How do I restore a PaperCut Print Archives?
PaperCut by default stores the Print Archive data in:
This location can be backed up using your existing backup processes and due to designed resilience can be restored fully or in-part allowing for partial backups of these files e.g. one or two months worth. The
README.txt in the archive directory that explains more about partial backups and the directory structure layout.
keywords: crash, restoration, back-up, point-in-time, export, image, storage