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:

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 of the contents available in <EventLog Analyzer Home>\mysql directory and save it as mysql_backup.zip in <EventLog Analyzer Home> directory.

Database backup procedure for MS SQL:

use eventlog
go
sp_helpfile
go

 

use master
go
sp_detach_db 'eventlog'
go

 

use master
go
sp_attach_db 'eventlog' , '<MSSQL Home>/data/eventlog.mdf' , <MSSQL Home>/data/eventlog_log.LDF
go

 

Get download link