XIV. Miscellaneous Questions

Backup VigorACS MySQL Database in Linux or Windows

Products:
Vigor ACS
VigorACS 3
Keywords:
automysqlbackup
backup
backuprestore
backuprestorescript
Show all

This article demonstrates how to back up the database of VigorACS running on Linux and Windows.

Before upgrading VigorACS, it's recommended to take a backup of the back-end database of the VigorACS system, MySQL. With the included backup scripts, it's possible to restore VigorACS to its original state with all of the important data, if there's a problem during the install that stops VigorACS from working correctly, it can be restored.
These scripts can be run on a schedule to keep regular backups of the MySQL data, each time the script is run it will take a new snapshot of the current VigorACS server state.

VigorACS Database Backup Scripts in Linux

1. Go to the directory /usr/local/vigoracs/VigorACS/bin/acs_util/dbutil/BackupRestoreScript/Linux and open the backup config file to edit it with "vi" or "nano": # sudo vi backupconfig.txt

2. Configure the following settings to match your VigorACS configuration so that the script can perform the backup.

The important items are highlighted in red, the MySQL Password and backup location must be set for the backup to proceed. In this example, the MySQL password is <blank> so it's not entered here.

Configure the settings in the backup config text file

3. Run this command:sudo ./automysqlbackup.sh to start the database backup.

Running the backup script

4. Check the saved data. If the script is successful in backing up the data, it will display a file similar to this:

Checking the backed up SQL data

To automate or schedule the backup task, add the task into "crontab" to have the database backup performed regularly.


VigorACS Database Backup Scripts in Windows

1. Go to the directory{ACS path}\bin\acs_util\dbutil\BackupRestoreScript\Windows and open the file “backupconfig_windows.txt”.

2. Configure the following settings to match your VigorACS configuration so that the script can perform the backup. The important items are highlighted in red:

3. Run automysqlbackup.bat in the command prompt as administrator to start the database backup process.

Running the backup script

4. Check the saved data. If the script is successful in backing up the data, it will display a file similar to this:

To automate or schedule the backup task, use the Windows Task Scheduler to have the database backup performed regularly.