Dump Mode Options
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. |
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 |
/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 |
/tmp |
tmp_dir=/othertmp |
timeout |
Timeout for SQL queries |
60 seconds |
timeout=1200 |
skip_missing_db |
Send a SKIPPED message instead of a warning when a database disapears during a job |
skip_missing_db |
|
abort_on_error |
Abort the job if we have MySQL connection problems |
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.
See also
Go back to:
Go to:
Go back to the Configuration page.
Go back to the main MySQL Plugin page.
Go back to the Dedicated Backup Solutions page.