This guide shows how to set up a connection from your JetBackup server to a MySQL database.
An example configuration page for the database connection:
A generic name for your internal ease of use, so it will be easier to recognize the database connection in case you have more than one. Max length is 40 characters.
The hostname/ip where the MySQL database is hosted.
Your remote database port (default port is 3306 - you must specify this even if it's 3306).
Please make sure that the port you are using for MySQL database connection is open in your database server firewall.
Name of the MySQL database user.
Password of the MySQL database user.
This option enables control over global transaction ID (GTID) information written to the dump file, by indicating whether to add a SET @@GLOBAL.gtid_purged statement to the output. This option may also cause a statement to be written to the output that disables binary logging while the dump file is being reloaded.
The maximum packet length to send to or receive from server
Continue even if we get an SQL error
Same as --add-drop-table, --add-locks, --create-options, --skip-opt.
This option tells the mysqldump utility not to issue a LOCK TABLES command before obtaining the dump which will acquire a READ lock on every table.
This option sets the transaction isolation mode to REPEATABLE READ and sends a START TRANSACTION SQL statement to the server before dumping data. It is useful only with transactional tables such as InnoDB, because then it dumps the consistent state of the database at the time when START TRANSACTION was issued without blocking any applications.