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';
 copy

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
 copy

3. Update config

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