• VigorACS

Vigor ACS-SI Database Restore

XV. VigorACS and VigorConnect

Products:
Vigor ACS
Keywords:
ACS-SI
Backup
Database
Restore

How to Restore a Vigor ACS-SI Database

This article explains how to restore a Vigor ACS-SI database which was previously backed up using the database backup script automysqlback_si.bat

Note: It is recommended that the restore is done on a machine running the same Vigor ACS version as the backup. If restoring a backup to a server running a newer Vigor ACS version then an 'upgrade' installation should be re-run on top of the installation after the restore has completed. Please contact support for any assistance.

These instructions explain how to restore a ACS-SI database in Linux

(Note, if your file extension is ".gz", please decompress it first)

1. Logon to the Vigor ACS-SI server as root

2. Locate the backup file. This may be in a folder name "/root/temp/mysqlbackups". Make a note of the location and backup file name.

3. In Linux, change path to /usr/local/vigoracs/VigorACS/dbutil/BackupRestoreScript/SI/Linux

4. Run mysqlrestore.sh /root/temp/mysqlbackups/now/tr069/tr069_2015-11-23_15h22m.Monday.sql

5. Logon to Vigor ACS-SI and check if database restore was successful.

Note: If also restoring a file backup of the C:\EMS directory (stores cfg backups and firmware files) please restore this first.

  1. Logon to the server that's running Vigor ACS-SI
  2. Locate the backup folder that contains the backup file and note the full path and name.
  3. Open a Command Prompt (eg Click start -> in the run box enter 'cmd')
  4. Change directory to c:\Program Files\VigorACS SI\dbutil\BackupRestoreScripts\SI\Windows\
  5. Run mysqlrestore.bat [path and file name from step 2]
    e.g. mysqlrestore.bat c:\mysqlback\backup_Tue-01-07.57PM01_.sql
    The duration taken to complete the restore will vary depening on how many nodes are in the VigorACS and how large the log files are
  6. Once the restore has completed it will be possible to Logon to Vigor ACS-SI to verify that the restore was sucessful

How do you rate this article?

1 1 1 1 1 1 1 1 1 1

Add a comment to this article

In the below box, you can add comments which you consider might be helpful to other users reading this article:

(Will be shown on your comment)
(Optional, Not shown/published)


NOTE : All comments are reviewed before publication and may not be posted or may be redacted if the editors do not consider them helpful. The use of offensive or obscene language, copyrighted material, or advertising or promotion or linking to any other product or service is prohibited. By submitting your comment, you confirm that you are the original author and assign copyright of the content to DrayTek indefinitely and irrevocably.