Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Deleting Databases and Starting Again

Hi

Our installation of LMS 3.2 is in a bit of a mess - what I would like to do is to delete all the databases and start again from scratch, but without reinstalling the whole suite.

Is this

a) recommended - or should I just do the fresh install

or

b) something that is easy to do.

Just to make it clear I want to get rid of all the current stuff thats in there (including devices, configs, archives the works) and start with a clean slate

Regards

Paul

4 REPLIES
Cisco Employee

Re: Deleting Databases and Starting Again

You can do this by reinitialzing the various LMS databases using the dbRestoreOrig.pl command:

NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=cmf dmprefix=Cmf

NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=rmeng dmprefix=RME

NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=ani dmprefix=ANI

NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM

NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=dfmInv dmprefix=INV

NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=dfmFh dmprefix=FH

NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=opsxml dmprefix=Opsxml

NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=ipm dmprefix=Ipm

NMSROOT/bin/perl NMSROOT/bin/dbRestoreOrig.pl dsn=upm dmprefix=UPM

The commands need to be run in that order.

Blue

Re: Deleting Databases and Starting Again

Would this be any different from restoring a copy of the dbbackup taken after a fresh install?

Cisco Employee

Re: Deleting Databases and Starting Again

If the backup was taken after install without doing ANYTHING else in LMS, then yes.

New Member

Re: Deleting Databases and Starting Again

Worked a treat - thanks for that.

209
Views
0
Helpful
4
Replies