Прескочи към главното съдържание
WARNING You're browsing the documentation for an old version of Deskpro. Consider updating to Deskpro Horizon.

MySQL Backup

в Backups
Списък с автори
Публикувани: 21.03.2017 г.|Последно обновено: 21.03.2017 г.

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.

ПолезноНе беше полезно
следваща страницаFile backup

Моля, логнете се или се регистрирайте, за да оставите коментар.