# MySQL

You can use the Commvault software to back up and restore MySQL databases.

## Backups

### Data You Can Back Up

- Individual database groups

- MySQL system databases

- MySQL user databases

- MySQL databases (data and logs)

### Data You Cannot Back Up

You can use a file server to back up the following content, which is not included in backups of MySQL databases:

- Operating system data

- MySQL application files

- MySQL Server information schema

- MySQL Server performance schema

### Backups You Can Perform

- Full backups

- Incremental backups

### When You Can Perform Backups

- On a schedule: The backup plan that you assign manages scheduled backups

- On demand: You can perform on-demand backups at any time

## Restores

### Data You Can Restore

- Entire Instance

- Individual databases

### Backups You Can Use for Restores

- The most recent backup: For example, restore the most recent backup to its original location

- A backup from a specific date: For example, restore data to a point in time before it became unusable

### Destinations You Can Restore To

- The same instance (in place)

- A different server or instance (out of place)

- A disk location

- You can restore MySQL databases from on-premise to cloud such as Amazon RDS, Amazon Aurora, Azure MySQL and Google Cloud

### MySQL Portability

You can perform the following cross-server restore operations.

Source | Destination
--- | ---
Windows | Linux
Windows | Yes | No
Linux | No | Yes

## SSL and TLS Support

SSL is supported for dump based backups for MySQL version 5.7 and later. The supported TLS versions to create MySQL instances are TLS 1.0, 1.1 and 1.2.

## Automatic Discovery of Applications

You can use the Auto discover applications option to automatically find MySQL databases in your environment and install software to back up the MySQL databases. For more information, see Automatic Discovery of Applications.

×

Loading...