1. Prepare New Server

Install Newest Version

The first step is to install a fresh version of Deskpro using any of the methods described in this manual. Use the navigation menu to the left to find the guide that suits you best.

Reset Deskpro (New Server)

You now have a simple, initial Deskpro running on a new server. Since you won’t actually be using this temporary/empty helpdesk instance, you must delete it.

From the command-line:

cd /path/to/deskpro
/path/to/php bin/console install:clean --keep-config

# Example on Linux
cd /opt/deskpro
/usr/bin/php bin/console install:clean --keep-config

# Example on Windows
cd C:\deskpro
"C:\Program Files\PHP\7.0\bin\php.exe" bin\console install:clean --keep-config
 copy

Running this command will completely delete the empty Deskpro installation and prepare it to accept the existing installation that you want to move here.

2. Disable your live helpdesk

From Admin > Setup, turn off your helpdesk so no new tickets or other work is done on it.

3. Export your MySQL database

Next, you need to move your MySQL database. You can do this by first making a database dump on the old server, and then importing the dump on the new server.

Old server: Make a backup

mysqldump --opt -Q --hex-blob -u<user> -p<pass> <dbname> > db-backup.sql
 copy

Move your MySQL database

You now need to move the database dump (db-backup.sql) from your old server to your new server (e.g. via SFTP). You may wish to gzip/zip the export to make the transfer quicker.

Import your MySQL database on the new server

mysql -u<user> -p<pass> <database> < db-backup.sql
 copy

4. Update config/ files on the new server

If you have imported your database into a different MySQL database than the one you have defiend in config/config.database.php, then you need to edit that file and set the proper database name.

If you have a data/encryption-key.bin file on your old server, copy it to the config/ directory.

5. Copy attachments/ to your new server

If you have attachments/blobs stored in the filesystem, you will need to move or copy the attachments/ directory from the old server to this new one.

If you are not storing blobs in the filesystem (the directory will be empty), you can skip this step.

6. Run database upgrade on the new server

The version of Deskpro you had on your old server may not be the same as the newest version you just downloaded. You need to run the following command to make the system update your database so its using the right schema:

cd /path/to/deskpro
/path/to/php bin/console dp:upgrade

# Example
cd /opt/deskpro
/usr/bin/php bin/console dp:upgrade

# Example on Windows
cd C:\deskpro
"C:\Program Files\PHP\7.0\bin\php.exe" bin\console dp:upgrade
 copy

Done

You have now migrated. Login to Deskpro and confirm the interface is functioning and there are no errors in the admin interface. You can then disable your old server.