MySQL Backup

Backups

To back up the MySQL database, use the mysqldump tool to create a backup file.

mysqldump is a standalone tool which is usually installed automatically when you install MySQL.

The recommended mysqldump command to use is:

mysqldump --opt -Q --hex-blob -u 'your user' -p'your password' your_db_name >
deskpro-backup.sql

(Note that there must NOT be a space between the the -p switch and your password.)

We recommend that you do this with the command line version of mysqldump, not through phpmyadmin.

Of course, you should then store the backup file on a separate server, secured from unauthorised access.

Note

You do not need to disable the helpdesk to do this backup.

Warning

This database backup is not enough to restore your helpdesk. You must also do the file backup below. Both are required for recovery.

Published: 21/03/2017

Last updated: 21/03/2017