A flexible data backup program that works with your existing hardware

MySQL Settings[For Windows]

Overview

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 "Add Backup Schedule" page.

In Windows, before a MySQL backup can be configured in GigaVaultStorage, you should configure the MySQL settings. Without correct values for these settings, GigaVaultStorage will not be able to list the databases to be configured for backups.

This section explains how to configure the MySQL settings so that GigaVaultStorage can list the MySQL database(s) in "Add Backup Schedule" page(For Windows).

How to get here in the GigaVaultStorage Web Console?

In the top menu, select: "Administration->Advanced Options" and click on the "MySQL Settings" icon in the left hand side.

MySQL Settings

In Windows, before a MySQL backup can be configured in GigaVaultStorage, you should configure the MySQL settings from "Administration->Advanced Options" menu "MySQL Settings" icon in the left hand side. With the values entered in the MySQL settings, GigaVaultStorage will create a backup dump of the MySQL database.

MySQL Server Name
This is a non-editable field. "localhost" will be used as the value.

MySQL Server Instance Port
By default MySQL server uses port 3306. But MySQL supports running multiple instances and in that case each instance will be using its own port. If you have just one instance of MySQL running, simply enter the port number here or leave the default as it is and save it. But if you have multiple MySQL instances running, then you can provide the ports for all the instances in the following manner:

Once you have configured one port for one of the instances and saved it, this field will have two options "1. Choose a port from the list" and "2. Add an additional port".

By selecting "Add an additional port" you can add additional ports for other MySQL instances running.

By selecting "Choose from the list", you can select any one of the ports already configured. This step is required before you configure MySQL backup from the "Add Backup Schedule" page. Depending upon the MySQL instance for which you want to configure the backup, you should first select the appropriate port, save it and then go backup to "Add Backup Schedule" page to configure MySQL backup for that instance. The MySQL databases listed in the "Add Backup Schedule" page (For Windows) will be for the MySQL Server instance whose port was last selected and saved from this MySQL settings page.

MySQL EXE Path
Enter the location of the mysql.exe file for the mysql server instance in the local machine. For example, if mysql.exe file is present in the "C:/Program Files/MySQL/MySQL Server5.0/bin/" folder, then enter "C:/Program Files/MySQL/MySQL Server5.0/bin/" as this field value. Please note that exe file name "mysql.exe" should not be appended to the path value.

MySQL Dump EXE Path
Enter the location of the mysqldump.exe file for the mysql server instance in the local machine. For Example, if mysql.exe file is present in the "C:/Program Files/MySQL/MySQL Server5.0/bin/" folder, then enter "C:/Program Files/MySQL/MySQL Server5.0/bin/" as this field value. Please note that exe file name "mysqldump.exe" should not be appended to the path value.

MySQL User Name
Provide the MySQL server instance authentication user name here. Note that each instance can have its own authentication user name and password. Make sure you give the correct user name matching the MySQL server instance you have chosen in the "MySQL Server Instance Port" field.

MySQL Password
Provide the MySQL server instance authentication password here. Note that each instance can have its own authentication user name and password. Make sure you give the correct user name matching the MySQL server instance you have chosen in the "MySQL Server Instance Port" field.

The option "Continue with previous authentication for this MySQL Server Instance" is provided if a user name and password have already been configured for the MySQL server instance. By default "Yes" option is selected and the "No" option could be used to change the previously saved "User Name" and "Password" values.

Temporary location to store the backup dumps
Enter the location/directory path to which the mysql database dumps has to be stored temporarily before uploading to the backup server. Please ensure that you have enough disk space in the configured temporary location (where the backup dump has to be saved). Please note that, backup dumps stored in the temporary location will be deleted once backup dumps are transferred successfully to the remote backup server.

Once these MySQL settings are correctly configured and saved, the tree in the "Add Backup Schedule" page will display the option to configure a mysql database backup.

Troubleshooting Tips

Database names is not listed in "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 dump is not created.

Cause : Entered 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).

Limitations

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.

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.

Backup Report/View Backup/Edit Backup UI pages does not provide the details like MySQL Server name, port etc.