OPManager 7 Database Problem
After hard rebooting the Windows 2003 SP2 server, we received an error on OPManager 7. The error states "Oops looks like a few tables got corrupted. Don't worry.. Run RepairDB.bat from bin directory and restart the server." We ran repairDB.bat and restarted the server serveral times but the problem persists. Please help us.
Here's the results of the repairDB.bat
myisamchk: MyISAM file ..mysqldataOpManagerDBefailover.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDB amedviewtoauthorizedviewtable.
MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDBoperationstreetable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
..mysqlinmyisamchk: File '..mysqldataOpManagerDBstatsdata11_3_2010.MYD'
not found (Errcode: 2)
myisamchk: error: File '..mysqldataOpManagerDBstatsdata11_3_2010.MYI' doesn'
t exist
..mysqlinmyisamchk: File '..mysqldataOpManagerDBstatsdata11_3_2010.MYD'
not found (Errcode: 2)
myisamchk: error: File '..mysqldataOpManagerDBstatsdata11_3_2010.MYI' doesn'
t exist
..mysqlinmyisamchk: File '..mysqldataOpManagerDBstatsdata11_4_2010.MYD'
not found (Errcode: 2)
myisamchk: error: File '..mysqldataOpManagerDBstatsdata11_4_2010.MYI' doesn'
t exist
..mysqlinmyisamchk: File '..mysqldataOpManagerDBstatsdata11_4_2010.MYD'
not found (Errcode: 2)
myisamchk: error: File '..mysqldataOpManagerDBstatsdata11_4_2010.MYI' doesn'
t exist
myisamchk: MyISAM file ..mysqldataOpManagerDBuonftable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDBurouptable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDBuasswordtable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDB iewpropertiestable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDB iewstogrouptable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDB iewtooperationstable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
Press any key to continue . . .
Thank you.
Here's the results of the repairDB.bat
myisamchk: MyISAM file ..mysqldataOpManagerDBefailover.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDB amedviewtoauthorizedviewtable.
MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDBoperationstreetable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
..mysqlinmyisamchk: File '..mysqldataOpManagerDBstatsdata11_3_2010.MYD'
not found (Errcode: 2)
myisamchk: error: File '..mysqldataOpManagerDBstatsdata11_3_2010.MYI' doesn'
t exist
..mysqlinmyisamchk: File '..mysqldataOpManagerDBstatsdata11_3_2010.MYD'
not found (Errcode: 2)
myisamchk: error: File '..mysqldataOpManagerDBstatsdata11_3_2010.MYI' doesn'
t exist
..mysqlinmyisamchk: File '..mysqldataOpManagerDBstatsdata11_4_2010.MYD'
not found (Errcode: 2)
myisamchk: error: File '..mysqldataOpManagerDBstatsdata11_4_2010.MYI' doesn'
t exist
..mysqlinmyisamchk: File '..mysqldataOpManagerDBstatsdata11_4_2010.MYD'
not found (Errcode: 2)
myisamchk: error: File '..mysqldataOpManagerDBstatsdata11_4_2010.MYI' doesn'
t exist
myisamchk: MyISAM file ..mysqldataOpManagerDBuonftable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDBurouptable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDBuasswordtable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDB iewpropertiestable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDB iewstogrouptable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: MyISAM file ..mysqldataOpManagerDB iewtooperationstable.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
Press any key to continue . . .
Thank you.