Dump Mode Configuration

With the Dump option (as opposed to the Binary option), the MySQL server should be configured with the binary log option to perform Incremental and Differential backups.

Note

If the mode plugin option is not specified, the backup will default to mode=dump.

Job {
 Name = "Mysql-dump"
 Client = laptop1-fd
 FileSet = FS_mysql_dump
 ...
}

FileSet {
 Name = FS_mysql_dump
 Include {
   Options {
     Signature = MD5
     Compression = GZIP
   }
   Plugin = mysql
 }
}

In the above example, the plugin will detect and back up all databases of your server. This simple configuration will work only if the root account is able to connect to the MySQL database. For more complex configurations, refer to the options table.

FileSet {
 Name = FS_mysql
 Include {
...
   Plugin = "mysql: database=bacula"
   Plugin = "mysql: database=master"
 }
}

In the above example, the plugin will backup databases bacula and master.

FileSet {
 Name = FS_mysql
 Include {
...
   Plugin = "mysql: unix_user=admin tmp_dir=/tmp"
 }
}

In the above example, the plugin will backup databases using the “admin” Unix user account. This account should be able to connect with all permissions to all databases that you want to dump. You need to make sure that the tmp_dir will be writable to your user.

In Dump mode, the MySQL plugin also accepts the parameters listed in the following Dump Mode Options (recommended to open in a new tab).

FileSet {
 Name = FS_mysql_dump
 Include {
...
   Plugin = "mysql: user=rob dump_opt=\"--ignore-table=db_name.tbl_name\""
 }
}

In this example, the MySQL Plugin will use MySQL account “rob” to perform a dump backup of all databases, and skip the table tbl_name in database db_name.

Note

Since 14.0.

In order to use sudo wrapper, you need to comment out the following option in /etc/sudoers.

Defaults requiretty

The MySQL Plugin permits different dump options for each MySQL version:

MySQL Dump options
Version	Option
>= 4.1.18	`--single-transaction --opt --extended-insert --create-options --default-character-set=utf8`
>= 5.0	4.1.18 options + `--routines --master-data=2`
>= 4.1	`--single-transaction --opt --extended-insert -all --default-character-set=utf8`
3.x	`--skip-lock-tables --opt --extended-insert --create-options --default-character-set=utf8`

Backup Level in Dump Mode

When using Dump mode, depending on the Job level, the MySQL Plugin will do the following:

For Full backups, the Plugin will backup all databases and logs generated during the backup.
For Incremental backups, the Plugin will flush the current log and will backup all logs generated since the last backup.
For Differential backups, the Plugin will flush the current log and will backup all logs generated since the last Full backup.