Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014
    Posts
    37

    Default 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. #2
    Join Date
    Apr 2011
    Posts
    210

    Default

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •