Configure MySQL Backup

• Overview
• How to get here in the GigaVaultStorage Web Console?
• MySQL Backup [For Linux, FreeBSD]
• MySQL Backup [For Windows]
• Troubleshooting Tips
• Limitations

Overview

Mysql server Backup is configured like any files and folders backup from the "Add Backup Schedule" page. All you have to do is to choose the databases under "mysql" entry in the tree and configure the backup.

This section explains how to configure the MySQL Backup from the "Add Backup Schedule" page(For Windows).

How to get here in the GigaVaultStorage Web Console?
 In the top menu, select: "Backup->Add Backup Schedule"

MySQL Backup [For Linux, FreeBSD]

To backup the MySQL databases, you need to install GigaVaultStorage with root privileges in your Linux, FreeBSD system and you should know the user name and password for MySQL. By default, GigaVaultStorage checks for 'mysql' under '/var/lib' folder in the system during the installation process.

Please note that you need to install GigaVaultStorage as root user (Option 1 during the installation) to list the mysql databases for backup in the 'Backup -> Add Backup Schedule' page.

If you have installed GigaVaultStorage with root user privilege [choosing Option 1 during the installation] and if you have installed MySQL in your machine, then 'mysql' and the databases will be listed in the tree in Step 2 in 'Backup -> Add Backup Schedule' page. Then, you can configure these folders for backing up the MySQL databases.

If the MySQL Server application is installed in a Linux, FreeBSD system, then GigaVaultStorage will automatically detect and list the 'mysql' folder in Step 2 in the 'Backups -> Add Backup Schedule' page (similar to 'System State', 'Registry'). You can select the mysql tree to backup the mysql databases to your Backup Server.

Please note that you have to provide mysql database username and password for the mysql backup to successfully dump the database data.

MySQL Backup [For Windows]

GigaVaultStorage can be configured to backup the MySQL Database(s) available in the local machine. GigaVaultStorage uses the internal MySQLDump utility (mysqldump.exe) to backup MySQL Database(s) and it uses the MySQL Exe (mysql.exe) to list the database names in the files/folders tree in the "Add Backup Schedule" page.

In Windows, before a MySQL backup can be configured in GigaVaultStorage, you should configure the MySQL settings through "Administration->Advanced Options" and click on the "MySQL Settings" icon in the left hand side. Without correct values for MySQL settings, GigaVaultStorage will not be able to list the databases to be configured for backups in "Add Backup Schedule" page.

If "mysql" entry is not shown in the "Add Backup Schedule" tree listing, read the MySQL Settings[For Windows] help for more details.

Troubleshooting Tips

	Database names are not listed in the files/folders tree in the "Add Backup Schedule" page(for windows).
Cause 1: If MySQL Settings for GigaVaultStorage is not configured. Solution : Configure MySQL settings from "Administration->Advanced Options" menu "MySQL Settings" icon in the left hand side and then check if MySQL database(s) are listed in the "Add Backup Schedule" page (for windows). Cause 2 : If MySQL service is not started in the machine. Solution : Start the MySQL service and then check if MySQL database(s) are listed in the "Add Backup Schedule" page (for windows). Cause 3 : When the last time MySQL Settings was saved for mysql server instance port, MySQL Exe path field value was not modified/edited, or may be an older version (MySQL 4) exe path value was entered for the newer version (MySQL 5) port. Solution : Enter the correct MySQL(version) Exe path value for the mysql server instance port selected. Cause 4 : mysqldatabase.lst file present in the "<SG_HOME>/plugins/MySQLServer/" folder does not have the database list. Solution : Check the MySQL version running in the machine (4.x or 5.x). GigaVaultStorage only supports listing MySQL 4.x and 5.x database(s) for backup.

	Database names are listed in "Add Backup Schedule" page(for windows), but backup dump is not created.
Cause : Configured username and password in the MySQL settings page may not have access to the database(s) configured for the backup schedule. Solution : Check if the user name and password entered in the MySQL settings have appropriate permissions to take a backup dump of the database(s).

	MySQL Server backups failed after recovering GigaVaultStorage client configurations from backup server through Client Disaster Recovery option.(for Windows)
Cause : MySQL Server details(UserName, Password, PortNumber) are not available in GigaVaultStorage client machine. Solution : In this case, save the MySQL Server details in MySQL Settings[For Windows] page before retrieving client configuration through Disaster Recovery option.

Limitations

1. Databases listed in the "Add Backup Schedule" page(For Windows) will be for the the last saved MySQL Server instance port in the MySQL Settings.
2. MySQL Settings edited/modified will not affect the mysql database backup schedules configured previously and changes will take effect only for the new mysql database backup schedules created.
3. Backup Report/View Backup/Edit Backup UI pages does not provide the details like MySQL Server name, port etc.