0

I had a problem similar to this in MySQL 5.7: Table is marked as crashed and should be repaired

When I used the tips in the thread to repair, the following happens:

Query:

REPAIR TABLE `<table>`

Result:

"database.<table>"  "repair"    "Error"  "Table ‘database.<table>' doesn't exist"

"database.<table>"  "repair"    "status" "Operation failed"

When I click on the table in HeidiSQL, I can view it normally. It only fails when I run a query.

Thanks all

clg5
  • 41
  • 5
  • Did you forget to put in **an actual / valid name** for ``? ie. `REPAIR TABLE AwesomeSauce`
     – user2864740 Sep 13 '18 at 21:19
  • 1
    Unfortunately no, I wish it was that simple – clg5 Sep 13 '18 at 21:20
  • Unless it is a 'sensitive' table name, it'd probably be good to update the post with the *actual* query and actual error messages.. – user2864740 Sep 13 '18 at 21:22
  • They are actually fairly sensitive, but I triple checked, the names are consistent, and all I changed was the actual names to database and table in the post. – clg5 Sep 13 '18 at 21:31

0 Answers0