Follow

Restoring Your MySQL Databases (Windows)

Requirements:

  1. These instructions are specifically for Windows Traverse installations
  2. These instructions will overwrite any existing data once you copy from the backup directories

 

Summary:

You will simply need to shut down Traverse components, then copy the directories under <TRAVERSE_HOME>\database\mysql to the specific BVE or DGE server. The instructions assumes the BVE servers and the DGE servers are split. In the case that you have a BVE+DGE combo, all the directories should apply on the same server. Once the backup files are copied over, run the commands to restore the databases. Following the commands should work whether you have a BVE+DGE combo or a split BVE and DGE.

 

Steps:

-Shut down Traverse components.

-Copy from <TRAVERSE_HOME>\database\backup\backup* to the following respective directories:
Applicable to BVE:
<TRAVERSE_HOME>\database\mysql\summarydb
<TRAVERSE_HOME>\database\mysql\schedulerdb
<TRAVERSE_HOME>\database\mysql\sladb
<TRAVERSE_HOME>\database\mysql\liveeventsdb

Applicable to DGE:
<TRAVERSE_HOME>\database\mysql\aggregateddatadb
<TRAVERSE_HOME>\database\mysql\processdb

 

-These commands are to restore the BVE MySQL databases:

cd <TRAVERSE_HOME>
net start nvdgedb


apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="SHOW TABLES" --database="liveeventsdb" > tables.txt
for /F "skip=1" %G IN (tables.txt) DO @apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="REPAIR TABLE %G USE_FRM" liveeventsdb >> logs\database_restore.log

apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="SHOW TABLES" --database="schedulerdb" > tables.txt
for /F "skip=1" %G IN (tables.txt) DO @apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="REPAIR TABLE %G USE_FRM" schedulerdb >> logs\database_restore.log

apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="SHOW TABLES" --database="summarydb" > tables.txt
for /F "skip=1" %G IN (tables.txt) DO @apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="REPAIR TABLE %G USE_FRM" summarydb >> logs\database_restore.log

apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="SHOW TABLES" --database="sladb" > tables.txt
for /F "skip=1" %G IN (tables.txt) DO @apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="REPAIR TABLE %G USE_FRM" sladb >> logs\database_restore.log

 

These commands are to restore the DGE MySQL databases:

cd <TRAVERSE_HOME>
net start nvdgedb


apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="SHOW TABLES" --database="aggregateddatadb" > tables.txt
for /F "skip=1" %G IN (tables.txt) DO @apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="REPAIR TABLE %G USE_FRM" aggregateddatadb >> logs\database_restore.log

apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="SHOW TABLES" --database="processdb" > tables.txt
for /F "skip=1" %G IN (tables.txt) DO @apps\mysql\bin\mysql --defaults-file=etc\mysql.conf --execute="REPAIR TABLE %G USE_FRM" processdb >> logs\database_restore.log

 

You may now turn on Traverse components

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.