In my mySQL database I noticed that there was a table missing from phpmyadmin. I tried creating the table but mySQL\u00a0reported that it already exist (it was a ghost table). I tried using mysqlcheck\u00a0to repair the database and it came back saying it the table didn’t exist. I then tried to create the table and mySQL returned an error message saying it already exists. That’s where I was totally CONFUSED!<\/p>\n

After some digging around and researching, I checked the \/var\/lib\/mysql\/[database]\u00a0 folder to see if the table name files existed and they were there. I deleted those files and copied them from another database but still had the same issue. After copying the files you need to change the file permissions of the copied files to the\u00a0mysql\u00a0service.<\/p>\n

chown -Rv mysql:mysql [database files]<\/pre>\n
 <\/p>\n
After a lot of digging around, I managed to work out the solution. I need to instal mysql-utilities and run this command:<\/p>\n
yum install mysql-utilities\r\n\r\nmysqlfrm --diagnostic [table_name].frm<\/pre>\n
After that, the table was fixed. You can then delete it.<\/p>\n
 <\/p>\n
DO YOU LIKE WHAT YOU'VE READ?<\/div>
Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!\r\n\r\n
\n
\n\n
Name<\/label>\n<\/div>\n
Email<\/label>\n<\/div>\n
\n<\/div>\n<\/form>\n<\/div>\n<\/p>\r\n\r\n<\/div><\/div>\n
<\/div>","protected":false},"excerpt":{"rendered":"
In my mySQL database I noticed that there was a table missing from phpmyadmin. I tried creating the table but mySQL\u00a0reported that it already exist (it was a ghost table). I tried using mysqlcheck\u00a0to repair the database and it came back saying it the table didn’t exist. I then tried to create the table and […]<\/p>\n","protected":false},"author":1,"featured_media":27027,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3897,497,1624,1713,747,1778],"class_list":["post-26979","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business","tag-corrupt","tag-database","tag-fix","tag-how-to","tag-mysql","tag-table"],"_links":{"self":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/26979","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/comments?post=26979"}],"version-history":[{"count":2,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/26979\/revisions"}],"predecessor-version":[{"id":27028,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/26979\/revisions\/27028"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media\/27027"}],"wp:attachment":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media?parent=26979"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/categories?post=26979"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/tags?post=26979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}