Knowledge Base
Home » Main » Restoring from backup

Restoring from backup

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:

[app-path]/server/data

from your latest off-disk backup. Remember to stop the PaperCut Application Server service before restoring (so the files are not in use at the time of restoration).

Or, alternatively it is possible to restore a point-in-time backup file as created by PaperCut's own backup procedure. These are stored in the directory:

[app-path]/server/data/backups

Again, you may need to restore your latest point-in-time backup 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 backup. Point-in-time backups can be imported into the system using the db-tools program as detailed in the user guide here:

http://www.papercut.com/products/ng/manual/ch-sys-mgmt-backups.html

and

http://www.papercut.com/products/ng/manual/apdx-tools-db-tools.html

PaperCut (External Database):

All data is stored in the external database with the exception of:

  • 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 backups (see above) in the directory:

[app-path]/server/data/backups

PaperCut Quota: [Legacy Software]

PaperCut stores data such as the user list, account balances, and activity logs in files labeled with an MDB file extension (*.mdb). PaperCut will automatically take backups of these important files during key operations such as a database “tune up”. Backups are placed in the directory:

C:\Program Files\PaperCut\Backups
In addition to PaperCut’s automated backup we strongly recommend that all PaperCut files (files under the PaperCut program folder) be included in a regular system-wide backup process.
If a database files needs to be restored from backup, use the following process:
1. Open Start->Settings->Control Panel->Administration Tools->Services
2. Select the "PaperCut" service(s) and press the stop button.
3. Copy the *.mdb file intended to be overwritten to a safe place on the hard drive.
4. Manually copy the *.mdb file from the backup pool over the top of the existing file. Ensure the file name is consistent with the original file name.
5. Restart the PaperCut services stopped in step 2.
6. Test PaperCut by instigating printing and/or internet use and ensure tracking continues as expected and no error messages existing in the PaperCut application event log.

Categories: Backups

keywords: crash, restoration, back-up

Page last modified on April 05, 2011, at 04:56 AM

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.