Restore a MySQL Server
MySQL databases can be restored to the original location or as a .sql file on disk that can be imported manually for restore to any compatible MySQL Server.
MySQL restores have additional requirements.
- The MySQL user specified on the Backup page must have the following privileges in order to restore the MySQL databases:
- CREATE, DROP, INDEX, SHUTDOWN, INSERT, ALTER, UPDATE, TRIGGER, SUPER, REPLICATION CLIENT, CREATE VIEW
- The MySQL client utilities (mysqldump and mysql) must be installed and the MySQL client version must be compatible with MySQL server.
- The MySQL server must be running at the time of restoration.
There are two ways to view databases for restore: SQL Files and Databases, each with its own benefits.
The SQL Files view is the default option for MySQL restores. This option is used when Restore All is selected, and is the default view shown when Restore Select is chosen.
A SQL File Restore will always include all databases that were backed up. Selective restore is not possible with the SQL Files restore view.
A SQL Files restore will create a .sql file on disk. This .sql file must be imported into any MySQL installation manually using MySQL tools or the command line.
The Databases view allows for individual databases to be selected for restore. A Databases restore will always restore the databases to their Original location and will import the databases into MySQL automatically.
The Databases view is only visible when Restore Select is chosen.
- Navigate to the Restore page and select a restore point.
- Click on Restore Select
- Change to the Databases view in the upper right.
- Select the databases to be restored.
- Click on Restore.