User guide

ManageEngine Firewall Analyzer :: User Guide
278
Zoho Corp.
Moving Firewall Analyzer's database to different
directory in the same server
To move the Firewall Analyzer's Indexes to a different drive/directory on the
same server
• Go to Archive Settings page.
• Enable Change Raw Logs Indexing Location check box.
• Modify the Log Indexing Location to the new location and save.
• Move all the directories from previous location to the new location.
How to move MySQL data to another drive in the same physical machine?
Follow the steps given below to move the database to a different drive:
• Stop the Firewall Analyzer server/service, if it is running.
• Check the task manager for the process java.exe and mysqld-nt.exe, kill
the process if any of these process is running.
• Copy the folder <Firewall Analyzer Home>\mysql\data to a folder in another
drive (e.g., D:\Firewall\data).i.e., the new location to which you want to move
the data of MySQL database.
• Rename the present data folder under mysql folder as dataold and you can
delete it later.
• Open the startDB.bat/sh file, located under <Firewall Analyzer
Home>\bin directory.
For Windows:
Edit the following command in the mysql startup line:
--datadir=%DB_HOME%\data
as
--datadir=D:\Firewall\data
where, the D:\Firewall\data is the new location for the MySQL database.
After changing the command, the start command will look like:
@start /B %DB_HOME%\bin\mysqld-nt --standalone --
basedir=%DB_HOME%
--port=%DB_PORT% --datadir=D:\Firewall\data --
innodb_buffer_pool_size=180M
--key-buffer-size=32M --innodb_file_per_table --max_heap_table_size=32M
--tmp_table_size=40M --innodb_flush_log_at_trx_commit=0 --log-error
For Linux:
Please add "--datadir=<desired location>" after "--basedir" attribute in
the mysql startup line.