Restoring a MySQL Server
- This article is for Windows only
Carbonite Safe Server Backup (CSSB) supports the restore of MySQL databases to their original location or as a .sql file on disk that can be imported manually to any compatible MySQL Server.
The Restore page in CSSB presents users with two ways to view databases for restore: SQL Files and Databases.
Restore Requirements
The following requirements must be met, whether restoring to the original computer or to an alternate computer:
- The amandabackup / CarboniteUser user must have full access to the folder where the backups are stored.
- For cloud backups, this is the chosen Download Folder.
- For local backups, this is the folder where the backups are stored on the local disk.
- If the backups are stored in a network location, amandabackup / CarboniteUser must have access to the network folder. Please refer to How to Use External or Mapped Network Drives with CSSB.
- Likewise, the amandabackup / CarboniteUser user must have full access to the folder(s) to which the backups are being restored.
Additional Requirements
- The amandabackup / CarboniteUser user 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 on the CSSB computer, and the MySQL client version must be compatible with MySQL server.
- The MySQL server must be running at the time of restoration.
Please choose the restore view that best fits your situation:
The sections below are collapsed. Please click the section title to open / close a particular section.
The SQL Files is the default view presented for MySQL restores. It creates a .sql file on disk that must later be imported into any MySQL installation manually.
- Navigate to the Restore page in the CSSB user interface, and select the backup run you want to restore.
- Use the SQL Files view and select the backup.sql file and its folder.
- Click Start My Restore.
- Once the restore is complete, import the .sql file into the MySQL Server.
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.
- Navigate to the Restore page in the CSSB user interface, and select the backup run you want to restore.
- Use the Databases view to select the databases to be restored.
- Click Start My Restore.
- When MySQL file is restored using this procedure, no MySQL recovery is performed.