Repairing a Severely Corrupted and Physically Unrepairable MySQL table


Yes genius, you’ve read it right. In this post, I’ll be writing about repairing a severely corrupted and physically unrepairable MySQL table. This is specific table is impossible to repair as you’ve tried all ways to repair it via SSH and cPanel using the Repair Database wizard or the myisamchk -r SSH command, but it always fail.

Once you’ve tried everything you can and you tested all ways that you found in Google from page 1 to 100, you will definitely lose hope and accept that fact that only magic or a miracle can repair a severely corrupted table.

But hey, don’t be sad. There are still ways to repair a seriously corrupted MySQL database or table. One is, removing the physical hard disk and attempt data recovery of the database files. You can use paid data recovery tools like GetDataBack or Diskeeper Professional. There are a lot of free and paid tools out there, you just need to choose.

If that doesn’t help, all you need to do is pray. God can fix everything if he wants to.

If God didn’t help you, too bad for you. You need to start from scratch again and make sure you have a daily remote backup of your database. In case it happens again, you just need to restore your recent stable backup.

One comment

  • markus
    April 12, 2012 - 2:41 am | Permalink

    Thanks for the advice your jerk!

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>