This document demonstrates how to restore the backup SQL file to the database of VigorACS 2 on Windows platform and Linux platform. Since the column and tables might be different for each version, please make sure the current ACS version is the SAME as the version where we backup the SQL file.
1. Go to the path {ACS Installed path}\bin\acs_util\dbutil\BackupRestoreScript\Windows
to find the file "backupconfig_si_windows.txt".
2. Edit the file backupconfig_si_windows.txt :
root
.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 by command# 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.
1. Go to the path /usr/local/vigoracs/VigorACS/bin/acs_util/dbutil/BackupRestoreScript/Linux
to find the file "backupconfig_si_windows.txt"
2. Edit the file backupconfig_si_windows.txt :
/usr/local/mysql/bin
3. Use the shell file mysqlrestore.sh and add the SQL file (including path) for running database restore by command# 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
Published On:2018-12-26
Was this helpful?