Migrating EventLog Analyzer from 32 bit to 64 bit Installation with MySQL Database


 

EventLog Analyzer lets users to migrate the existing 32 bit EventLog Analyzer installation to 64 bit installation with MySQL database.

 

The steps to migrate from 32 bit to 64 bit installation and run the Eventlog Analyzer server with MySQL as the database is given below:

  1. Download the mysqldump zip file from the URL below:

http://bonitas.zohocorp.com/patches/cherry/22Feb2011/mysqldump_windows.zip

  1. Extract the zip file in <EventLog Analyzer Home>/mysql/bin directory
  2. Shutdown the EventLog Analyzer server/service
  3. Backup the following folders by copying or zipping it and save in a different location
<EventLog Analyzer Home>\mysql
<EventLog Analyzer Home>\server\default\indexes
<EventLog Analyzer Home>\archive
  1. Open a Command Line Window in the EventLog Analyzer server and go to <EventLog Analyzer Home>\bin folder and start the MySQL. Execute the startDB.bat file
  2. Go to the folder <EventLog Analyzer Home>\mysql\bin folder and execute the following command

mysqldump --add-drop-table --add-drop-database -u root --port=33335 -h localhost --databases eventLog -f -r dump.sql

 

note

If you receive any error in the above step, contact EventLog Analyzer support

  1. This process would take 30-40 minutes, depending on MySQL size. After completing the above process, stop the MySQL server. Execute the stopDB.bat file in the <EventLog Analyzer Home>\bin\ directory
  2. Pick the dump.sql file and place it some where out of EventLog Analyzer installation folder
  3. Download the 64 bit EventLog Analyzer file from the Download page and install it.
  4. Start the EventLog Analyzer service and ensure you can connect the web client to access it
  5. Stop the EventLog Analyzer service
  6. Delete the following files in the <EventLog Analyzer Home>\mysql\data folder:
  7. Place the dump.sql in the new installation location, under <EventLog Analyzer Home>\mysql\bin directory
  8. Go to <EventLog Analyzer Home>\bin folder and start the MySQL. Execute the startDB.bat file
  9. Go to the folder <EventLog Analyzer Home>\mysql\bin folder and execute the following command

mysql -u root -h localhost --port=33335 < dump.sql

  1. Stop the MySQL server. Execute the stopDB.bat file in the <EventLog Analyzer Home>\bin\ directory
  2. Replace the following folders (from the backup taken) in the new installation
<EventLog Analyzer Home>\server\default\indexes
<EventLog Analyzer Home>\archive
  1. Start the EventLog Analyzer service and ensure you view the old data
Copyright © 2012, ZOHO Corp. All Rights Reserved.
ManageEngine