Moving EventLog Analyzer's database to different directory in the same server


To move the Eventlog Analyzer's Indexes to a different drive/directory on the same server

To move the Eventlog Analyzer's database to a different drive/directory on the same server

Moving MySQL Database

  1. Stop the Eventlog Analyzer Server/Service.
  2. Check the task manager for the process 'mysqld-nt.exe' and 'SysEvtCol.exe', kill the process if any of these processes are running.
  3. Copy the 'data' folder under <Eventlog Analyzer Home>\mysql to a folder in another drive. (for example: D:\Eventlog\data)
  4. Kindly rename the present 'data' folder under 'mysql' as 'dataold' and you can delete later.
  5. Edit (in notepad) the file "StartDB.bat", which is located under <Eventlog Analyzer Home>\bin folder and edit the following command in the mysql startup line:

"--datadir=%DB_HOME%\data" as "--datadir=D:\Eventlog\data"

 

whereas, the D:\Eventlog\data is the new folder on D:\ drive.

  1. Save the file.
  2. Start the Eventlog Analyzer Server/Service.
  3. Check whether the data is fine and the D:\Eventlog\data size is getting increased.

Moving MSSQL Database

  1. Stop the Eventlog Analyzer Server/Service.
  2. Login to SQL Server database with system administrator permissions.
  3. Find the current location of the data file and log file for the database eventlog by using the following commands:

use eventlog
go
sp_helpfile
go

  1. Detach the database by using the following commands:

use  master
go
sp_detach_db 'eventlog'
go

  1. Copy 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).
  2. Re-attach the database and point to the new location by using the following commands:

use  master
go
sp_attach_db 'eventlog' , '<New Location>\eventlog.mdf' , '<New Location>\eventlog_log.LDF'
go

  1. Verify the changed location by using the following commands:

use eventlog
go
sp_helpfile
go

  1. Start the Eventlog Analyzer Server/Service.

 

 

 

Copyright © 2012, ZOHO Corp. All Rights Reserved.
ManageEngine