Jump to content

Recover from lost tables from InnoDb ibdata1 files


path2u

Recommended Posts

I am really hoping someone can help us ... from lightworker.com a non-profit company who just lost our dedicated server hard drive. We discovered shortly afterwards that our backup service backed up the web directories, but NOT the MySQL DB's themselves. OUCH !!!

We have Fedora Core 4 dedicated server, running Plesk control panel, with MySQL ver: 4.1.20-1.FC4.1

We recovered some of our DB's, but not the most critical ones, and I noticed while searching through the recovered hard drive data that

there is a large ( 18.8G ) ibdata1 file in the /var/lib/mysql/ directory. I found out that this is the data file for the InnoDB type of setup.

What I am hoping is that, our data can be recovered from this in some way, even if this means we end up converting to InnoDb as our default DB afterwards. Can anyone here help me, or point me in a direction that could help ??

thanks a ton,

Jesse

???

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.