| | | |
 Uploading ....
RepairDB using MysqlcheckSometimes the DB might get corrupted and the Central/Probe does not start. Usually repairdb tool is used, which invokes myisamchk. Also you can make use of mysqlcheck, which provides more advanced switch options to
optimize the DB. mysqlcheck and myisamchk are similar in function to each other. The main difference between them is that mysqlcheck must be used when mysqld server is running, whereas myisamchk should be used when it is not running. The advantage of using mysqlcheck is that you need not to stop the server to check or repair the DB. Consider the following steps to repair the DB using mysqlcheck.
- Please download this mysqlcheck.zip
file and extract this into the \mysql\bin folder of the Central/Probe [whichever DB has got corrupted].
- Execute this command from the Central and/or Probe as given below.
- Central > Central\mysql\bin\mysqlcheck\mysqlcheck\bin> mysqlcheck.exe
-f -r -u root -P 23306 centraldb
- Wait till the mysqlcheck gets completed in the Central and then go to probe machine and execute as given below.
- Probe > Probe\mysql\bin\mysqlcheck\mysqlcheck\bin> mysqlcheck.exe -f
-r -u root -P 33306 dmsdb
|
|
|
| | | |
|
