dbRestoreOrig.pl, reinitdb.pl, dbsrv9 : which use when?

Unanswered Question
Aug 8th, 2007


Can someone explain me the differences between these scripts? When should one use which tool?



I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4 (1 ratings)
Joe Clarke Wed, 08/08/2007 - 05:47

reinitdb.pl is for the ANI database only. It allows one to either drop all of the Data Collection related tables, or the User Tracking related tables, or replace the entire ANI database. The latter simply calls dbRestoreOrig.pl. Note: dropping the Data Collection and UT tables may cause problems in Campus Manager 4.0.x. These have been fixed in Campus 5.0.

dbRestoreOrig.pl can be used on any of the dmgtd-controlled databases. These include cmf, rmeng, ani, dfmInv, dfmEpm, and dfmFh. The script replaces the current database with a clean original copy.

dbsrv9 is the actual database server. This is not a script, but a binary executable. This is responsible for opening the database and handling client requests.

If you're using LMS 2.x, I recommend you stick with dbRestoreOrig.pl whenever your databases become corrupt, and you you do not have a known good backup.

yjdabear Wed, 08/08/2007 - 05:50

Would the IPM db be covered under the dbRestoreOrig.pl umbrella in the future?


This Discussion