Wednesday, April 29, 2015

Chapter 3: Backup and Restore Applications Manager data


The following are the methods for backing up Applications Manager, check them and use the one appropriate to you.
  • Via Script File.
    Use the BackupMysqlDB.bat /.sh or BackupPGSQLDB.bat/.sh available in <AppManager Home>/bin directory to take a backup copy inclusive of conf files of Applications Manager and the database backup. In this backup we take configuration files of MySQL or PGSQL DB, Applications Manager tool and data stored in DB. To restore these files back into Applications Manager you can use the RestoreMysqlDB.bat / .sh or RestorePGSQLDB.bat/.sh file in the same directory. Kindly refer the help https://www.manageengine.com/products/applications_manager/help/appendix/data-backup.html. Applications Manager can be running while taking backup, but to restore we have to stop it.
For Example:
[root@poller1 AppManager10]# cd bin


[root@poller1 bin]# ls


BackupMysqlDB.sh ReportMysqlDataMigration.sh


createSupportFile.sh RestoreMysqlDB.sh


exportCertificateToAppManager.sh ServerSSHTroubleshoot.sh


migrateI18Nfor9.sh troubleshooting


optimizeMysqlDB.sh UniqueIDLinux.sh


Recorder.exe updateLicense.sh


reinitialize.sh updateManager.sh


repairMysqlDB.sh


[root@poller1 bin]# sh BackupMysqlDB.sh


Starting mysqld daemon with databases from /home/appmanager/ManageEngine/AppManager10/AppManager10/working/mysql/data


Data successfully backed up in the file /home/appmanager/ManageEngine/AppManager10/AppManager10/working/backup/AM_back_up_2015-04-27_09_41_33.sql


Apr 27, 2015 9:43:18 AM com.adventnet.appmanager.util.MysqlZip main


INFO: length 1


Apr 27, 2015 9:43:18 AM com.adventnet.appmanager.util.MysqlZip main


INFO: backupfile


Apr 27, 2015 9:43:18 AM com.adventnet.appmanager.util.MysqlZip getFileName


INFO: backupfile


Apr 27, 2015 9:43:18 AM com.adventnet.appmanager.util.MysqlZip main


INFO: Zipping the databases


INFO: Data successfully backed up in /home/appmanager/ManageEngine/AppManager10/AppManager10/working/backup/backupzip_Apr_27_2015_9_43_18/backupzip_Apr_27_2015_9_43_18.zip


STOPPING server from pid file /home/appmanager/ManageEngine/AppManager10/AppManager10/working/mysql/data/poller1.pid


150427 09:44:59 mysqld ended






You have new mail in /var/spool/mail/root



  • DB backup alone (for MySQL backend only)
    Applications Manager stores all information of the resources it monitor's in it's database. Hence you can just copy the database folder. The database folder location is<App Manager Home>/working/mysql/data/AMDB. To restore this backup you just need to replace the backup copy in AppManager_home/working/mysql/data/folder (rename the existing folder). Applications Manager must be stopped while copying the AMDB directory.
  • Complete Backup (for MySQL backend only)
    This method takes a complete backup of everything in Applications Manager. Like the DB, Conf files & patches already applied in the build you are using. Here you just need to make a copy of the AppManager_home folder either zip it up or copy and paste it in a different location. To restore just paste the backup copy to the same location (rename the existing folder). Applications Manager must be stopped while copying the <App Manager Home> directory.
  • If the Application Manager build is below 8010 please contact our appmanager-support@manageengine.com team for assistance.
  • Note: These steps are for MySQL / PgSQL backend database. If you are using MSSQL , take backup of the corresponding database in your MSSQL server using steps in this after stopping Applications Manager.
    To take the configuration files alone as backup you can run BackupConfig.bat (sh) /RestoreConfig.bat (sh) available in<
    AppManager Home>/bin directory.



Share this

0 Comment to "Chapter 3: Backup and Restore Applications Manager data"

Post a Comment