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.

2 Comments

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

    Thanks for the advice your jerk!

  • Sean Julian
    May 1, 2013 - 4:04 am | Permalink

    The most common “data recovery” scenario involves an operating system (OS) failure (typically on a single-disk, single-partition, single-OS system), in which case the goal is simply to copy all wanted files to another disk. This can be easily accomplished using a Live CD, many of which provide a means to mount the system drive and backup disks or removable media, and to move the files from the system disk to the backup media with a file manager or optical disc authoring software. Such cases can often be mitigated by disk partitioning and consistently storing valuable data files (or copies of them) on a different partition from the replaceable OS system files.^.

  • Leave a Reply

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