Announcement

Collapse
No announcement yet.

MySQL Table in use, but table does not repair in phpmyadmin

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Table in use, but table does not repair in phpmyadmin

    Currently, I am facing weird issue – when I try to repair table through phpmyadmin it doesn’t repaid and MySQL says table in use and the worst thing is system says “the table is already up to date”; any suggestion?

  • #2
    Sometimes mysql corrupts itself due to some reasons and it doesn’t responds to “Repair” and return with a message – table in use. If you have root access to your machine, here are some simple steps to resolve the issue:

    #cd /var/lib/mysql/DATABASE (where DATABASE is the one you're trying to fix)

    #myisamchk --safe-recover TABLE (where TABLE is the table you are trying to fix)

    This will repair the table in safe mode, and should result in success.

    Comment

    Working...
    X