MySQL

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?

  • 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:

  • MySQL application files

  • Operating system data

  • MySQL Server information schema

  • MySQL Server performance schema

Loading...