Backup

Estimate Information

The estimate command will display all information found by the MySQL plugin. For Dump mode, Bacula cannot estimate the dump size for databases, so it will display database size instead.

Backup Information in Dump Mode

The MySQL Plugin will generate the following files entries in the Bacula catalog for a server having a single database “test”.

/etc/mysql/my.cnf
@MYSQL/main/gobal-grants.sql
@MYSQL/main/settings.txt

@MYSQL/main/test/createdb.sql
@MYSQL/main/test/schema.sql
@MYSQL/main/test/data.sql
@MYSQL/main/test/grants.sql

@MYSQL/main/logs/mysql-bin.000001

Backup Content in Dump Mode

File	Context	Comment
global-grants.sql	global	List of all users, their password and specific options
settings.txt	global	Current variables for the mysql server
my.cnf	global	MySQL server configuration
createdb.sql	database	Database creation script
schema.sql	database	Schema database creation script
data.sql	database	Database data in dump format
grants.sql	database	List of all users associated to the database

See also

Go to Restore.

Go back to the main Operations page.

Go back to the main MySQL Plugin page.

Go back to the Dedicated Backup Solutions page.