Sysadmin Guide

Restoring from backup


1. Prepare new database

First, create a new database within MyQSL. You'll also need to create a new MySQL user or give your existing user permission to the new database.

Example:

CREATE DATABASE deskpro_restored;
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';
GRANT ALL PRIVILEGES ON  `deskpro_restored`.* TO 'myuser'@'localhost';

2. Restore database

Then you can restore the database dump into this new database. From the command-line, use the mysql utility:

mysql -umyuser -p deskpro_restored < backupname.sql

3. Update config

Finally, you need to modify config/config.database.php to update the database name and user/password.

Comments (0)

Add a comment

Add a comment

You need to log in before you can submit a comment.

Need a password reminder?