Carbonite Support > MySQL Server Backup

MySQL Server Backup

  • This article is for Windows only

Summary:

Carbonite Safe Server Backup (CSSB) supports logical backup of MySQL Server version 5.x. Only full backups of MySQL servers are currently supported. CSSB doesn't backup MySQL binary logs.

Carbonite Safe Server Backup also supports backup of specific MySQL databases, and the backup of specific tables but only from one MySQL database. It does not support selecting specific tables from multiple MySQL databases.

Note: You can either backup a local MySQL server or a remote MySQL server.

For more details about backing up MySQL including information on various backup settings, please refer to the Carbonite Safe Server Backup User Guide.

Solution:

The sections below are collapsed. Please click the section title to open / close a particular section.

How to Perform a MySQL Server Backup

To configure MySQL server backups, create a new backup set and choose MySQL from the list of backup types. You will be required to specify the MySQL server information and user credentials of the user that can perform the backup. MySQL client path refers to the directory where the MySQL client utilities compatible with your MySQL server are located.

Carbonite Safe Server Backup assumes the following defaults.

  • My SQL Server: localhost.
  • Port: 3306.
  • Parameters: --lock-all-tables

These defaults work for most MySQL instances. Please change them if necessary. Two common exceptions are listed below:

  • If the MySQL instance uses a socket file for connection instead of a port, please leave the Port field blank.
  • Using the --single-transaction parameter instead of the default of --lock-all-tables may result in increased performance and lower CPU usage during backup and configuration of MySQL instances using the INNODB storage engine.

After filling in the details, click the Discover button. CSSB will connect to the MySQL server and read the databases and tables present within.

Requirements for Backing Up MySQL Server
  • The amandabackup / CarboniteUser user should have sufficient privileges to perform logical backup from the CSSB machine. The minimal set of privileges required are as follows:
    • For backup: LOCK TABLES, SELECT, FILE, RELOAD, SUPER, UPDATE, TRIGGER, SHOW VIEW.
    • For restore: CREATE, DROP, INDEX, SHUTDOWN, INSERT, ALTER, UPDATE, TRIGGER, SUPER, REPLICATION CLIENT, CREATE VIEW.
  • MySQL client utilities (mysqldump and mysql) must be installed on the CSSB machine and the MySQL client version must be compatible with MySQL server.
Feedback