How do I backup my database?
Below are the procedures for backing up data from PostgreSQL, MySQL and MS SQL databases.
Note: Before starting the backup process, stop EventLog Analyzer service.
Database backup procedures for PostgreSQL (For Build#8010 and above):
Take a backup of the existing EventLog Analyzer PostgreSQL database by creating a ZIP file of the contents available in <EventLog_Analyzer_Home>/pgsql directory and save it as pgsql_backup.zip in <EventLog_Analyzer_Home> directory.
Database backup procedure for MySQL:
Take a backup of existing EventLog Analyzer MySQL database by creating a ZIP file for the contents of <EventLog_Analyzer_Home>/mysql directory and save it as mysql_backup.zip in <EventLog_Analyzer_Home> directory.
Database backup procedure for MS SQL:
Find the current location of the data and log file for the database eventlog by using the following commands
Detach the database using the following commands:
Backup the data file and log file from the current location <MSSQL_Home>/data/eventlog.mdf and <MSSQL_Home>/data/eventlog_log.LDF to the new location <New_Location>/eventlog.mdf and <New_Location>/eventlog_log.LDF.
Re-attach the database and point to the old location by using the following commands
sp_attach_db 'eventlog' , '<MSSQL Home>/data/eventlog.mdf' , <MSSQL Home>/data/eventlog_log.LDF