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.

Go back to the Configuration page.

Go back to the main MySQL Plugin page.

Go back to the Dedicated Backup Solutions page.