You can back up and restore MySQL databases.

Backup and Restore Capabilities

Most basic backup and restore capabilities are available for MySQL.

Backup Capabilities

Type of capability

Detailed information

What you can back up

Individual database groups.

Types of backups that you can perform

  • Full backups.

  • Incremental backups.

When you can perform backups

  • On a schedule. You can have multiple schedules for each database group.

  • Immediately.

Restore Capabilities

Type of capability

Detailed information

Time periods from which you can restore data

  • From the most recent backup.

  • From a specific date/time.

Destinations that you can restore data to

  • In-place: Restore data to the location from which it was backed up.

  • Out-of-place: Restore data to the following different destinations

    • A server that is within the same MySQL organization

    • A disk location

What Is Backed Up?

What Is Backed Up

  • MySQL system databases

  • MySQL user databases

  • MySQL databases (data and logs)

What Is Not Backed 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

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.