We have launched the new version of the DrayTek website, and this content is no longer being maintained.
You will find more information on our new site; however, we will keep this page for a few months.

How to restore the sql file on VigorACS 2 database?

This document is going to demonstrate how to restore the backup sql file on your database. Since ACS will adjust the column/table for each version; therefore, please make sure the ACS version is the SAME as the backup sql file before we restore the database.


 

 

Windows Platform

  1. Go to the path {ACS Installed path}\VigorACS\dbutil\BackupRestoreScript\SI\Windows, and we'll see the "backupconfig_si_windows.txt" file there.

  2. Edit the file backupconfig_si_windows.txt :
    • USERNAME: Input the MySQL account to access the database. If you install the MariaDB from VigorACS installed package, the default account should be "root".
    • PASSWORD: Type the password of MySQL account to access the database. If you forgot the password, please refer the document What can I do if I forgot the MySQL password?
    • Database path: Specify the correct path of MariaDB bin folder.

  3. Launch the Command Prompt and change the path to the {Installed path}\VigorACS\dbutil\BackupRestoreScript\SI\Windows.
    Use the batch file mysqlrestore.bat and add the sql file(including path) for running database restore.  
    # mysqlrestore.bat C:\Users\User\AppData\Roaming\EMS\sql-backup\backup_ACS_2.4.0RC3_r10622_FullVer_2018-12-11.1724.sql

    You will see the message "Restore process is finished. please check it" after restore process completed.

 

Linux Platform

  1. Go to the path /usr/local/vigoracs/VigorACS/dbutil/BackupRestoreScript/SI/Linux, and we'll see the "backupconfig_si_windows.txt" file there.

  2. Edit the file backupconfig_si_windows.txt :
    • USERNAME: Input the MySQL account to access the database. If you install the MariaDB from VigorACS installed package, the default account should be "root".
    • PASSWORD: Type the password of MySQL account to access the database. The default password should be blank if you never change it before.
      If you forgot the password, please refer the document What can I do if I forgot the MySQL password?
    • Database path: Specify the correct path of MariaDB bin folder. If you install the mysql via ACS installation program, the path should specify as /usr/local/mysql/bin

  3. Use the shell file mysqlrestore.sh and add the sql file(including path) for running database restore.  
    # mysqlrestore.sh /home/mysql_backup/backup_ACS_2.4.0RC3_r10622_FullVer_2018-12-12.1400.sql

    You will see the message "Restore process is finished. please check it" after restore process completed.

 

See Also:

Was this article helpful?
9How to restore the sql file on VigorACS 2 database? has been viewed------ 9 ------times.