This feature allows you to backup ANY local/remote MySQL database.
Basically the backup consists of a SQL script file that actually represents a script able to recreate the whole database content from scratch. For each table it contains SQL statements that will recreate:
- the tables structure
- the tables indecs/keys
- the tables records
This backup file may be later used as a safe copy, to migrate the database manually to another MySQL server or just to restore it automatically on the same server using the Restore Wizard add-on.
Note that this feature will use also the MySQL database maintenance feature to check/repair the MySQL database before the backup is made.
If you would prefer a more robust MySQL backup option like mysqldump then you may be interested in the Backup MySQL via mysqldump add-on.