Deleting Databases and Starting Again

Unanswered Question
Jan 12th, 2010
User Badges:


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


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



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Joe Clarke Tue, 01/12/2010 - 12:22
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

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

NMSROOT/bin/perl NMSROOT/bin/ dsn=cmf dmprefix=Cmf

NMSROOT/bin/perl NMSROOT/bin/ dsn=rmeng dmprefix=RME

NMSROOT/bin/perl NMSROOT/bin/ dsn=ani dmprefix=ANI

NMSROOT/bin/perl NMSROOT/bin/ dsn=dfmEpm dmprefix=EPM

NMSROOT/bin/perl NMSROOT/bin/ dsn=dfmInv dmprefix=INV

NMSROOT/bin/perl NMSROOT/bin/ dsn=dfmFh dmprefix=FH

NMSROOT/bin/perl NMSROOT/bin/ dsn=opsxml dmprefix=Opsxml

NMSROOT/bin/perl NMSROOT/bin/ dsn=ipm dmprefix=Ipm

NMSROOT/bin/perl NMSROOT/bin/ dsn=upm dmprefix=UPM

The commands need to be run in that order.

yjdabear Tue, 01/12/2010 - 12:29
User Badges:
  • Gold, 750 points or more

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

Joe Clarke Tue, 01/12/2010 - 12:32
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

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


This Discussion