MYSQL recovery

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.

                New to ADManager Plus?

                  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 ...
                    • Database Migration from Mysql to Postgres in NetFlow Analyzer version 10250

                      Steps to Migrate NetFlow Standalone Mysql DB to pgsql Datase Note: Migration is applicable only in build 10250 Both the MYSQL and PGSQL installation should be in the same server to perform the Migration. Make sure that you have enough disk space ...
                    • 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> ...