|
|
|
|
How Tos > Backup and Restore with same Database
Backup and Restore Instructions For the same Database
This file contains the necessary instructions for carrying out a simple
db backup or db restore process with the script files available in this
folder <OpManagerHome>\bin\backup. Please be noted that the application should be stopped before
attempting any backup or restore process.
ManageEngine OpManager DE supports two database management systems as
database back-end viz. MySQL and MS SQL. You have the option of using any one
of these two and can later migrate from one system to another. However we
strongly suggest you use MS SQL from the beginning itself as it improves scalability.
Windows
1. Mysql Backup and Mysql Restore
In order to back up the system which is running on MySQL database and
later to restore on MySQL itself, you need to run BackupDB_MySQL.bat,
to take the backup and RestoreDB_MySQL.bat, to restore the file.
The backed up file has to be given as an argument when running the RestoreDB_MySQL.bat script.
It is to be noted that there will be two files created when a backup is made using BackupDB_MySQL.bat
viz. a '.sql' file and a '.bak' file. The '.bak' file has to be used
for restoration purposes. Also it is important that you should always
give a '.bak' file when using RestoreDB_MySQL.bat script, and not any other file extensions.
2. MS SQL Backup and MS SQL Restore
Though there are backing up tools available in the MS SQL installation
itself, it might be necessary to take a backup of the MS SQL database
from the application.
a) To backup MS SQL database run
BackupDB.bat present under
<OpManagerHome>
\bin\backup
b)
To restore the same, use RestoreDB.bat with the fully qualified backup file name passed
as an argument
LINUX
Only MySQL database support is available in Linux. Run BackupDB.sh,
to take the backup of the MySQL database and RestoreDB.sh, to restore the file.
The backed up file has to be given as an argument when running the RestoreDB.sh script.
To configure Backup file location while backup
You can take the backup at the particular location you want in the same machine where the server is runnign. Follow the steps below.
A. Mysql(Windows and Linux)
- Stop the Central/Probe that you want to backup.
- Execute the corresponding backup script from <Central/Probe_Home>/bin/backup directory to start the data backup as follows
For Windows:
BackupDB_MySQL.bat backupDir <location where you want to store the backup data>
For Linux:
BackupDB.sh backupDir <location where you want to store the backup data>
For eg:
BackupDB_MySQL.bat backupDir C:\OpManager DE BackupFile --> For Windows
BackupDB.sh backupDir /home/guest/OpManager DE BackupFile --> For Linux
|
Document Saved Successfully
|
|
|
|
|
|
|
