# “MySQL” Backup

This Protected Item type backs up a MySQL database. It is also compatible with MySQL-compatible servers such as MariaDB and Percona Server. It works at the logical (SQL) level.

No data is spooled to the local disk. As per the "Program Output" type, no progress bar or ETA appears during a MySQL backup.

Databases are backed up one-at-a-time. Point-in-time consistency is only preserved on a per-database basis.

### Connection details

Connection details should be supplied before selecting databases. Fill in the fields at the bottom of the dialog window.

### Selecting databases

Use the plus button on the right to open a database browser, allowing you to select individual databases for backup. Use the dropdown-plus button to add a custom property.

### Custom mysqldump

eazyBackup Backup's MySQL support works at the logical (SQL) level using mysqldump. A copy of this program must be found on the device in order for the backup job to run.

The mysqldump binary is selected as follows:

* If a custom path to mysqldump has been set, this binary is used.
* Otherwise, if there is a version of mysqldump installed (e.g. you are backing up a MySQL server from the server itself), the local version of mysqldump will be used to ensure maximum compatibility.
* Otherwise, if no copy of mysqldump can be found, the Windows version of eazyBackup Backup bundles a recent mysqldump binary in compliance with its license.
* If no suitable mysqldump binary is found, the MySQL backup job will fail with an error message Couldn't find 'mysqldump' anywhere. This failure can be detected via the backup job's status or its log entries.

#### On Linux, you can install a copy of mysqldump as follows:

| **Distro**     | **Command**                  |
| -------------- | ---------------------------- |
| Debian, Ubuntu | apt-get install mysql-client |
| CentOS, RHEL   | yum install mysql            |

### System databases

EazyBackup supports backing up the built-in system databases if desired.

* The mysql database contains server configuration, including user accounts and grants. It should only be restored to the same major release of MySQL.
* The information\_schema database is a set of read-only views and does not need to be restored.
* The performance\_schema database is a set of aggregated statistics and does not need to be restored.
* [The sys database](https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html) (in MySQL 5.7.7 and higher) is a set of performance statistics and does not need to be restored. If your version of MySQL does not successfully back up this table, it is safe to exclude it from the eazyBackup Backup settings.

### Isolation modes

> *This feature is available in eazyBackup 19.3.0 and later.*

eazyBackup allows you to select the isolation mode used when reading data from MySQL. You should select the most appropriate isolation mode for your MySQL engine type.

The following options are available:

<table data-header-hidden><thead><tr><th width="139"></th><th width="132"></th><th width="130"></th><th></th></tr></thead><tbody><tr><td><strong>Isolation Mode</strong></td><td><strong>InnoDB</strong></td><td><strong>MyISAM</strong></td><td><strong>Detail</strong></td></tr><tr><td>Transaction</td><td>Consistent</td><td>Inconsistent</td><td>Wrap all read access in a single transaction, so that the read data is consistent</td></tr><tr><td>Lock tables <em>(default)</em></td><td>Consistent, but slow</td><td>Consistent, but slow</td><td>Lock access to database before reading it, so that the read data is consistent. This requires that the MySQL user account has been granted the LOCK TABLES permission</td></tr><tr><td>None</td><td>Inconsistent</td><td>Inconsistent</td><td>Do not take a transaction and do not lock tables.</td></tr></tbody></table>

***

[eazyBackup](https://eazybackup.com)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.eazybackup.com/documentation/mysql-backup.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.