It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda Backup

Protecting MySQL Databases

  • Last updated on

You can protect MySQL databases by using native tools to create a backup dump file or by configuring a pre-execute script on the Barracuda Backup Agent.

Create a Batch File

Use the mysqldump command to create a MySQL database dump file.

Here is the syntax to create the batch file:

cd\
cd "<path-to-mysql-server-location>"
mysql -u <privileged_account> -p -c -B mysqldump.exe <database_name> > <path-to-location-to-dump-the-database><name-of-script>

An example of how to create a batch file using the mysqldump command:

  1. Verify the Barracuda Backup Agent is installed on all systems to be backed up.
  2. Open a text editor, for example Notepad, and type the following lines:
    cd\
    cd "Program Files (x86)\MySQL\MySQL Server 5.6\bin"
    mysql -u root -p -c -B mysqldump.exe database_name > c:\temp\dump.sql

    Replace MySQL Server 5.6 with the MySQL server version, replace root with the account with privileges the database, replace database_name with the database name, and replace c:\temp\dump.sql with the directory and file name of the location where you want to dump the database.

  3. Save the text file as a batch (.bat) file:
    batch_file.png 

Configure Agent to Run the Pre-Execute Script

You can pre-execute your batch file prior to running a backup.

Here is the syntax to edit the [configuration] section in the config.ini file:

[configuration]  
# Comment 
preExecuteScript=<path-to-backup-agent><name-of-script>

Use the following steps to modify the config.ini file:

  1. Open the Services console. Right-click the Barracuda Backup Agent service, and click Stop.

  2. Navigate to the config.ini file on the server:

    C:\Program Files\Barracuda\Barracuda Backup Agent\config\
  3. Open the config.ini file in a text editor, and in the [configuration] section, enter the following lines:
    # Batch file to backup mysql database
    preExecuteScript="C:\mysqlbk.bat"

    Replace C:\mysqlbk.bat with the path location and your batch file name.

  4. Save and close the file.