Carbonite Support > Restoring a MySQL Server

Restoring a MySQL Server

  • This article is for Windows only

Summary:

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.

Solution:

The Restore page in CSSB presents users with two ways to view databases for restore: SQL Files and Databases.

Note: Ensure that the Restore Requirements and Additional Requirements are met before starting the restore.

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.
  • 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 CSB 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.

SQL Files View

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.

  1. Navigate to the Restore page in the CSSB user interface, and select the backup run you want to restore.
  2. Use the SQL Files view and select the backup.sql file and its folder.
  3. Click Restore Now.
  4. Once the restore is complete, import the .sql file into the MySQL Server.
Databases View

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.

  1. Navigate to the Restore page in the CSSB user interface, and select the backup run you want to restore.
  2. Use the Databases view to select the databases to be restored.
  3. Click Restore Now.
  4. When MySQL file is restored using this procedure, no MySQL recovery is performed.
Feedback