Binary Mode Options

MySQL Plugin Options in Binary Mode
Option	Comment	Default	Example
mode	Enable Binary backup	dump	mode=binary
unix_user	MySQL Unix user	root	unix_user=mysql
service	MySQL server information	main	service=main
prepare	Use Percona prepare on the File daemon	fd	prepare=fd
prepare	Use Percona prepare on the Storage daemon		prepare=sd
user	MySQL super user	root	user=root
password	MySQL super password		password=xx
backup_software	MySQL backend (mariadb, xtrabackup, mysql). Used to determine the tools to use.``10``	mysql	backup_software=mariadb
bin_dir	MySQL binaries location		bin_dir=/5.1/bin
bin_format	Binary format (tar or xbstream)	xbstream	bin_format=tar
config_file	Path to my.cnf mysqld configuration file	/etc/mysql/my.cnf
mycnf_dir	Path where the MySQL connection `.my.cnf` file is stored		mycnf_dir=/opt/bacula/etc
extra_file	Path to mysql connection file `1`	/root/extra.cnf
tmp_dir	`WorkingDirectory` Where the plugin will create files and scripts for the database backup. `2`		tmp_dir=/othertmp
timeout	Timeout for SQL queries `3`	60 seconds	timeout=1200
abort_on_error	Abort the job if we have MySQL connection problems `4`		abort_on_error=true
xtrabackup_tmpdir	Set `tmpdir` option when doing binary backup `5`		xtrabackup_tmpdir=/tmp/test
xtrabackup_args	Set additional options when doing binary backup `6`		xtrabackup_args=”–compress”
restore_extract	Extract xbstream archive automatically at restore `7`		restore_extract
innobackupex_tmpdir	Deprecated `8`		innobackupex_tmpdir=/tmp/test
innobackupex_args	Deprecated `9`		innobackupex_args=”–compress”

1 Available with Bacula Enterprise 8.2.4 and later.

2 Available with Bacula Enterprise 6.6.6 and later.

3 Available with Bacula Enteprise 8.6.15.

4 Available with Bacula Enterprise 8.2.9 and later.

5 Available with Bacula Enterprise 8.2.8 and later.

6 Available with Bacula Enterprise 8.2.9 and later.

7 Available with Bacula Enterprise 10.2 and later.

8 Available with Bacula Enterprise 8.2.8 and later. Deprecated since Bacula Enterprise 10.2.

9 Available with Bacula Enterprise 8.2.9 and later. Deprecated since Bacula Enterprise 10.2.

10 May be necessary only in special scenarios such as binary bundle package installations. Available with Bacula Enterprise 16.0.8 and later.

Note that the tar option for bin_format is not compatible with Incremental backups, so only the Full backup will be stored in tar format. Incremental backups will use the xbstream output format.