Skip to main content

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.


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.

Authors list

First published: 21/03/2017

Last updated: Feb 28, 2018 by Christopher Nadeau