Personally, I experienced this with the Bugzilla software issue tracking software. The message I got on the browser screen is as follows.<\/p>\n
\nSoftware error:<\/b><\/p>\n
DBD::mysql::db selectrow_array failed: Can’t open file: ‘logincookies.MYI’ (errno: 145) [for Statement "SELECT profiles.userid, profiles.disabledtext FROM logincookies, profiles WHERE logincookies.cookie=? AND logincookies.userid=profiles.userid AND logincookies.userid=? AND (logincookies.ipaddr=? OR logincookies.ipaddr=?)"] at Bugzilla\/Auth\/Cookie.pm line 69<\/p>\n
Bugzilla::Auth::Cookie::authenticate(‘Bugzilla::Auth::Cookie’, 5, 4928) called at Bugzilla\/Auth\/CGI.pm line 106<\/p>\n
Bugzilla::Auth::CGI::login(‘Bugzilla::Auth::CGI’, 1) called at Bugzilla.pm line 74<\/p>\n
Bugzilla::login(‘Bugzilla’) called at C:\/bugzilla\/buglist.cgi line 81<\/p>\n
For help, please send mail to the webmaster (…@……), giving this error message and the time and date of the error.\n<\/p>\n
To resolve the issue, I first stopped the MySQL database.<\/p>\n
\nC:>net stop mysql\nThe MySQL service is stopping..\nThe MySQL service was stopped successfully.\n<\/pre>\nThen, I issued the myisamchk.exe command as below to recover the table that became corrupted; for me, it was the logincookies.MYI file.<\/p>\n
\nC:>c:mysqlbinmyisamchk.exe -r logincookies.MYI\n- recovering (with sort) MyISAM-table 'logincookies.MYI'\nData records: 158\n- Fixing index 1\n- Fixing index 2\n<\/pre>\nOnce the recovering process was completed, I restarted the MySQL database.<\/p>\n
\nC:>net start mysql\nThe MySQL service is starting.\nThe MySQL service was started successfully.\n<\/pre>\nOnce the MySQL restart is completed, the database was functioning properly once again, and my Bugzilla system was running without a hitch. Alternatively, I could have logged in to MySQL and issued the following SQL command to repair the corrupted table.<\/p>\n
\nuse bugzilla;\nrepair table logincookies.MYI;\n<\/pre>\n","protected":false},"excerpt":{"rendered":"If your application gives you a message similar to “Can’t open file: ‘*.MYI’ (errno: 145)”, you are likely experiencing a MySQL corruption problem on a particular table. This note details how to recover from this problem fairly easily.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-96","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/posts\/96","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/comments?post=96"}],"version-history":[{"count":0,"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/posts\/96\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/media?parent=96"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/categories?post=96"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/tags?post=96"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}