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 following steps to configure the Barracuda Backup Agent to use a pre-execute script to create a MySQL database dump file:
- 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 sakila > c:\temp\test.sql
- Save the text file as a batch (.bat) file:
Configure Agent to Run the Pre-Execute Script
Use the following steps to modify the config.ini file to pre-execute your batch file prior to running a backup:
Open the Services console. Right-click the Barracuda Backup Agent service, and click Stop.
Navigate to and open the config.ini file in a text editor, located in the C:\Progarm Files\Barracuda\Barracuda Backup Agent\config directory.
Enter the following lines below the configuration section:
#Batch file to backup mysql database
- Save the file.