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
copy(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
Note
You do not need to disable the helpdesk to do this backup.
Warning
Warning
This database backup is not enough to restore your helpdesk. You must also do the file backup below. Both are required for recovery.
Please log in or register to submit a comment.