Sets a backup profile that defines
be backed up,
where the backup should be
when (the frequency) it should be
backed up. The main page:
The Online Backup page is separated into three sections:
Backup Jobs: Used for managing backup jobs for the MySQL server. A backup job (profile) is a configuration file used to store information about what is backed up, where the backup is stored, and optionally when backups will be performed.
Right-clicking on a Backup Job is an alternative way to access
the available actions, such as
Delete Job, and
Execute Backup. Right-clicking also offers
two additional options:
Execute Backup to Image File: Saves the backup to a single file, and prompts for the file name.
Copy Backup Command to Clipboard:
Generates a command for executing the backup, and copies
it to your clipboard. You might execute this command in
the shell or terminal, which looks similar to:
--show-progress=stdout backup --with-timestamp.
Backup Job Details: Displays information about the state of a specific (selected) backup job. It includes information from the Settings page, and information specific to the selected backup.
Recent Activity: Historical information
about the backup operations performed on the server. View the
backup log by right-clicking an entry and choosing
View Backup Log
Executing a backup will show a dialog with the progress of the backup operation.
Creating a backup job offers several elements. The following information applies to the New Job operation, and Configure Job is used to modify existing jobs.
The Backup Profile Name and its associated Comments field are used to identify the backup job's profile, and this name is listed on the main page.
The New Job scheduling page separates the configuration information into three tabs. The Contents tab defines the schemas and tables to back up, and whether the job is a full or partial backup.
Full backup: All schemas and tables are
Incremental: Select the schemas and tables
(objects) that you want to back up. Select an object from the
left Objects in this Instance box, and
press the > arrow button to schedule
the selected object under Objects to
Backup. The Show System
Schemas option shows system schemas, such as
The Options tab includes setting that modify the default behavior of the backup process.
By default, the Backup Storage Directory is
stored under a sub-folder using the name of the Backup
Profile Name in the
MySQL Backup Home
Directory setting. The compression and
apply-log operation options are also set here.
The Schedule tab optionally sets a backup schedule for both full and incremental backups. The schedule uses the Windows Tasks Scheduler on Microsoft Windows, and a cron job on Linux and Mac OS X. It is scheduled using the operating system user that is scheduling the backup, which is typically the MySQL user.
A full backup is slower than the incremental backup that merges with a full backup. A common scenario is to set a full backup as weekly, and an incremental backup as daily. For additional information about backup performance, see Optimizing Backup Performance.
To recover backups, see Section 9.2.3, “Backup Recovery”.