Restoring from backup

Backups

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.

Published: 21/03/2017

Last updated: 28/02/2018