MySQL Administrator :: 12.1 Introduction

This section allows you to create backup projects, and to perform backups. This section will produce backup files that are plaintext and composed of multiple SQL statements that can be executed to restore your database, similar to the output generated by the mysqldump utility. For more information on mysqldump, see the mysqldump section of the reference manual.

Existing backup projects are listed in the lower left area of the sidebar. If there are many backup projects, the field with the magnifying-glass icon can be used to filter the projects you are looking for. Typing in t or T, for example, will set the filter to projects whose names begin with a t. The filter works in a case-insensitive fashion.

You can update the list of backup projects by right-clicking on a project and choosing the Refresh Backup Projects option from the drop-down menu. You can delete a backup project by right-clicking on the project and choosing the Delete Backup Project(s) option from the drop-down menu.

If you are not working from a previously saved backup project, click the New Project button to create a new backup project. You cannot begin configuring a backup operation without either loading an existing project or creating a new project.

Once you have configured your backup project, you can click the Save Project button to save your project for future use. To start your backup, click the Execute Backup Now button. You will be prompted for a path and filename for the backup file, after which the backup operation will begin.