MYSQL recovery
To recover MYSQL DB which had failed to work recently, follow the steps below -
1 - Stop netflow analyzer service
2 - Make sure there are no mysqld-nt.exe or java.exe processes running.
3 - Navigate to %Netflow%\BIN and edit startDB.bat/sh with a wordpad/notepad
4 - Append the argument '--innodb_force_recovery=4'.
It should look like this -
@ echo off call "%~dp0\setcommonenv.bat" @start "MySQL" /B "%DB_HOME%\bin\mysqld-nt" --no-defaults --standalone --innodb_force_recovery=4 --basedir="%DB_HOME%" --port=%DB_PORT% --
5 - Run startDB.bat/sh and wait for 3-5minutes.
6 - Run stopDB.bat and ensure the mysqld-nt.exe terminates.
7 - Open startDB.bat and undo the changes made.
6 - Start the Netflow analyzer service.
1 - Stop netflow analyzer service
2 - Make sure there are no mysqld-nt.exe or java.exe processes running.
3 - Navigate to %Netflow%\BIN and edit startDB.bat/sh with a wordpad/notepad
4 - Append the argument '--innodb_force_recovery=4'.
It should look like this -
@ echo off call "%~dp0\setcommonenv.bat" @start "MySQL" /B "%DB_HOME%\bin\mysqld-nt" --no-defaults --standalone --innodb_force_recovery=4 --basedir="%DB_HOME%" --port=%DB_PORT% --
5 - Run startDB.bat/sh and wait for 3-5minutes.
6 - Run stopDB.bat and ensure the mysqld-nt.exe terminates.
7 - Open startDB.bat and undo the changes made.
6 - Start the Netflow analyzer service.
New to ADSelfService Plus?
Related Articles
Mysql to Pgsql/Mssql -- Plugin
Mysql to Pgsql/Mssql Migration Plugin: Stop Opmanager service and take a backup of the entire Opmanager folder before doing the data migration. Install Opmanager 11500 pgsql with Netflow 10250 (for mssql, select mssql DB during installation). from ...Firewall Analyzer Mysql to Pgsql migration steps.
Stop the Firewall Analyzer Service. Take the backup or a VM snapshot of ManageEngine\Firewall folder. Download the correct zip files based on your OS(32/64bit) from the below link and extract it under <Firewall Analyzer Home>. ...NFA Password Reset steps for Mysql database till version 10250
Kindly follow steps as given below to reset the password. Please note that the NetFlow Analyzer Server is running before doing the below steps. 1. Open a command prompt 2. Go to the <NETFLOW_HOME>\mysql\bin directory 3. Type For Windows : mysql ...Device Expert 5990 migration from Mysql to Pgsql
Please follow the steps to migrate DeviceExpert data from mysql to postgres. Note: .bat is for Windows and .sh is for linux installation. DeviceExpert Backup steps : Please stop DeviceExpert. IMPORTANT: Take a copy of the entire <DeviceExpert> ...Mysql 32 bit installation to 64 bit Migration. (Up to build 9700 which has MySQL as default DB)
Please follow the below steps to migrate from your current 32 bit installation to 64 bit. STEPS: 1. Shut down Old NetFlow Analyzer service. 2. Backup the below directories \ files to a safe location. Note that these are 2 different directories but ...