User guide

ManageEngine Firewall Analyzer :: User Guide
279
Zoho Corp.
After adding the "--datadir" attribute to the command, the start command
will look like:
#default
$DB_HOME/bin/mysqld --no-defaults --basedir=$DB_HOME --
datadir=/advent/5g/Working/Latest/data --port=$DB_PORT --
socket=$TMP_HOME/mysql.sock --user=root..............
The above command may slightly differ for various builds, however, ensure
that,
in Windows "--datadir=%DB_HOME%\data"
is changed to "--datadir=<new drive with absolute path>"
or
in Linux "--datadir=<new drive with absolute path>" is added.
• Save the file.
• Start the Firewall Analyzer server/service.
• Check whether the data is correct and the D:\Firewall\data directory size is
getting increased.
Moving MSSQL Database
1. Stop the Firewall 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 firewall by
using the following commands:
use firewall
go
sp_helpfile
go
4. Detach the database by using the following commands:
use master
go
sp_detach_db 'firewall'
go
5. Copy the data file and log file from the current location (<MSSQL
Home>\data\firewall.mdf and <MSSQL Home>\data\firewall_log.LDF)
to the new location (<New location>\firewall.mdf and <New
Location>\firewall_log.LDF).
6. Re-attach the database and point to the new location by using the following
commands:
use master
go
sp_attach_db 'firewall' , '<New Location>\firewall.mdf' , '<New
Location>\firewall_log.LDF'
go