Do you have any questions that I can help you with?
Corrupt Database Problems
Why can PaperCut's database become corrupted?
A full disk or any sort of disk corruption such as those cause by power outages or unexpected system shutdown/failures can corrupt the PaperCut database.
How do I restore a PaperCut database if the database is corrupted?
You will need at least one good backup file from the backup directory [app-dir]\server\data\backups\. To restore the database follow these instructions:
Option 1 - restore via our own backup software
If you have an off disk backup, simply:
- Stop the PaperCut Application Server service (Control Panel->Admin Tools->Services), or run the stop-server script in
[app-dir]\server\bin\[platform]if running on Linux or Mac. - Restore all files and folders located at:
[app-dir]\server\data\internal
Option 2 - restore using one of PaperCut's point-in-time backups
1. Logon to the PaperCut server.
2. Stop the PaperCut Application Server service (Control Panel->Admin Tools->Services), or run the stop-server script in
[app-dir]\server\bin\[platform] if running on Linux or Mac.
3. As a backup, take a copy of the
[app-dir]\server\data\internal\ directory.
4. Open a command prompt (cmd.exe).
5. Change to the
[app-dir]\server\bin\[platform]\ directory. e.g. cd "C:\Program Files\PaperCut NG\server\bin\win\"
6. Run the following command to re-initialize the database:
db-tools.exe init-db -f
7. Then restore your backup into the database by doing the following (changing the backup file name as appropriate)
db-tools.exe import-db "C:\Program Files\PaperCut NG\server\data\backups\export-2009-05-10T00-20-03.zip"
8. Once completed, restart the application server service.
Categories: Backups
keywords: corrupt, database, restore, derby error, database connection error
Page last modified on March 01, 2010, at 06:10 PM