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:
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:
- Verify the Barracuda Backup Agent is installed on all systems to be backed up.
Open a text editor, for example Notepad, and type the following lines:
cd "Program Files (x86)\MySQL\MySQL Server 5.6\bin"
mysql -u root -p -c -B mysqldump.exe database_name > c:\temp\dump.sql
- Save the text file as a batch (.bat) file:
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:
Use the following steps to modify the config.ini file:
Open the Services console. Right-click the Barracuda Backup Agent service, and click Stop.
Navigate to the config.ini file on the server:C:\Program Files\Barracuda\Barracuda Backup Agent\config\
Open the config.ini file in a text editor, and in the [configuration] section, enter the following lines:
# Batch file to backup mysql database
- Save and close the file.