{"id":865,"date":"2012-12-18T16:29:20","date_gmt":"2012-12-18T16:29:20","guid":{"rendered":"http:\/\/www.andrewhope.co.uk\/Blog\/?p=865"},"modified":"2022-05-14T18:47:47","modified_gmt":"2022-05-14T17:47:47","slug":"repairing-corrupted-mysql-tables","status":"publish","type":"post","link":"https:\/\/www.andrewhope.co.uk\/Blog\/repairing-corrupted-mysql-tables\/","title":{"rendered":"Repairing corrupted MySQL tables"},"content":{"rendered":"

OK, so whilst using my stats monitoring software (tracewatch) it decided to bomb out on me and say the database was corrupted and needed repairing!<\/p>\n

Example screen shot below….<\/p>\n

\"corrupted<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

It’s a nice simple program but I think my HDD is on the fritz so ended up getting errors all over the place and eventually received a message that it was corrupted and needed repairing<\/p>\n

Basically the following is the commands I used to repair the database
\n{you must<\/strong> use a semicolon after each command}<\/p>\n

– First open a command prompt (start > run > cmd) (run as admin on windows 7)
\n– Then change to your mysql\\bin directory (i.e c:\\cats\\dogs\\mysql\\bin)
\n– Then enter the following command: mysql -u(yourDBUN) -p(yourdbpassword (default is root for UN)
\n– When logged in enter the name of your database with a semicolon following it
\n– If you are not sure type the command “show databases;” and press enter
\n– Then when you find the database type “use DBNAME;”<\/p>\n

– Enter the below command (if you don’t know the table name {use show tables; if not sure})<\/p>\n

\"show<\/a>
\n– Your database should then be selected, after this enter the command “check table TABLENAME;”
\n– A message will probably be outputted its corrupted. Then just enter “repair table TABLENAME;” and after this everything should be repaired<\/p>\n

\"table<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

OK, so whilst using my stats monitoring software (tracewatch) it decided to bomb out on me and say the database […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wprm-recipe-roundup-name":"","wprm-recipe-roundup-description":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":"","_links_to":"","_links_to_target":""},"categories":[4],"tags":[113,105,110,109,104,111,112,106,108,107],"class_list":["post-865","post","type-post","status-publish","format-standard","hentry","category-it","tag-checking-tables","tag-corrupted","tag-how-to-repair-mysql-tables","tag-how-to","tag-mysql","tag-mysql-repair-commands","tag-repairing-tables","tag-table","tag-table-commands","tag-table-repair"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t