Dump Mode Options

MySQL Plugin Options in Dump Mode
Option	Comment	Default	Example
dump_opt	This string will be passed to the mysqldump command		dump_opt=”-X”
exclude_table	Exclude a table. Multiple parameter is allowed. If the argument points to a file on the client, each line will be excluded. `5`		exclude_table=mysql
unix_user	Unix user to use for MySQL commands	root	unix_user=robert
service	MySQL server name		service=main
mycnf_dir	Path where MySQL .my.cnf file is stored		my_cnf=/tmp
use_sudo	Use sudo instead to run MySQL commands (when not root)		use_sudo
database	Will backup on databases matching this string		database=prod*
all_databases	Will generate a single dump of all databases
bin_dir	MySQL binaries location		bin_dir=/opt/mysql/bin
user	MySQL super user	root	user=root
password	MySQL super password		password=xx
logbin_dir	mysqld log_bin directory
config_file	Path to my.cnf mysqld configuration file	/etc/mysql/my.cnf
extra_file	Path to mysql connection file `1`	/root/my.cnf
character_set	Character set used to dump data	utf8	character_set=utf8
tmp_dir	Where the MySQL plugin will create files and scripts for the database backup `2`	/tmp	tmp_dir=/othertmp
timeout	Timeout for SQL queries `3`	60 seconds	timeout=1200
skip_missing_db	Send a SKIPPED message instead of a warning when a database disapears during a job `6`		skip_missing_db
abort_on_error	Abort the job if we have MySQL connection problems `4`		abort_on_error=true
backup_software	MySQL backend (mariadb, mysql). Used to determine the tools to use.``7``	mysql	backup_software=mariadb

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.0 and later.

5 Available with Bacula Enterprise 14.0 and later.

6 Available with Bacula Enterprise 14.0.4 and later.

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