Knowledgebase: PaperCut
Papercut External Database Migration
Posted by Matthew Ryan, Last modified by Zak Devlin on 11 October 2017 10:22 AM
Pre migration steps
 
1) Ensure the current implementation using the internal database is functioning correctly with no reported issues.
 
2) Backup Papercut from the admin console | Options Tab | Backup Tab | Export Now button. Rename backup to export.zip , this avoids typo's in later steps then copy it to the root of C drive E.G C:\export.zip for simplicity in later steps. You can find the backup in the "./papercut mf/server/data/backups/" folder 

 
Migration process
 
1) Stop Papercut services on the server
 
2) Open the file ./papercut MF/server/server.properties. This file contains your database connection settings, and admin password, etc. Update the file appropriately by remarking out the internal DB and unremarking the external DB such as SQL. You will need to add the SQL server name and database name, the sql username and password for this database.
e.g.
### Database Settings ####

# database.type=Internal
#database.driver=
#database.url=
#database.username=
#database.password=


# MS SQLServer connection example
# IMPORTANT: The username below is a SQL Server user, not a Windows user.
database.type=SQLServer
database.driver=net.sourceforge.jtds.jdbc.Driver
database.url=jdbc:jtds:sqlserver://sql-server/papercut
database.username=PCut_User
database.password=Password1
 
3) Save the file Server.properties file
 
 
Restore backup on server
 
1) Stop Papercut services on server
2) From the command prompt .\Papercut mf\server\bin\win perform the following commands
3) db-tools init-db -f
4) db-tools import-db -f "C:\export.zip" 
5) Restart Papercut services
6) Logon to admin console.
 
 

 Papercut KB Links:

Configuring Microsoft SQL Server


Configuring Microsoft SQL Server Express

(3 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: