MySQL

The MySQL plug-in acts as a common MySQL client application and provides access to MySQL databases and tables. File system provided by the plug-in is organized as follows:

Folders correspond to MySQL databases. Folder attributes are not supported.

Files correspond to tables. File attributes are not supported.

Since the plug-in provides no attributes for folders and files, it cannot be effectively used with incremental backup option, i.e. allows for differential backup only. To learn how the software works with file attributes, please refer to Plug-in File Systems.

File system provided by the MySQL plug-in. Folders are databases, files are tables.

Format of the Backup Files

The software creates database dump files, one file per table. Each backup file is named after the respective table and contains all SQL statements required to create the table and fill it up with data. The format is very understandable and can be easily modified prior to restoration (provided that you keep the SQL syntax correct).

At present, the plug-in supports only the DROP-CREATE method that suggests that restoration of the backup will firstly delete database or table, and then rebuild it from zero.