Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 05-12-2013, 08:30 AM   #1
LQ Newbie
Registered: May 2013
Posts: 13

Rep: Reputation: Disabled
Mysql Recovery Question

My Hardrive with Mysql Crashed and was able to recover everything in the mysql directory apart from the mysql/mysql folder which mysql server is dependent upon.

All individual databases, ibdata1, ib_logfile0 and ib_logfile1 are still intact. When those individual databases where used to overwrite newly created database folders on a new Server, they work perfectly for databases created in the MyIsam format but all InoDB databases are not working. I have noticed that there are no .idb files in the respective database folders.

Is it still possible to get back my DBs done in InnoDB format?

Thanks for the anticipated replies.
Old 05-12-2013, 01:18 PM   #2
LQ Addict
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian stable
Posts: 5,898

Rep: Reputation: 353Reputation: 353Reputation: 353Reputation: 353
Here is a link to a thread which discusses that problem. It contains links to other files which describe to procedure. I don't pretend to understand it all. I hope it helps you.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: How to backup MySQL and recovery Using Zmanda Recovery Manager LXer Syndicated Linux News 0 09-10-2008 05:30 AM
LXer: MySQL Backup And Recovery With mysql-zrm On Debian Sarge LXer Syndicated Linux News 0 09-28-2006 09:21 AM
mysql disaster recovery? dbc001 Slackware 6 09-24-2006 04:28 PM
MYSQL DB Recovery zgauthier Linux - Software 2 12-18-2004 02:01 PM
Help mysql innodb recovery from .frm pig.2003 Linux - Software 0 11-10-2004 03:35 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:38 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration