LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 05-12-2013, 08:30 AM   #1
Dataguyz
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
bigrigdriver
LQ Addict
 
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian stable
Posts: 5,877

Rep: Reputation: 350Reputation: 350Reputation: 350Reputation: 350
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.

http://dba.stackexchange.com/questio...and-a-ibd-file
 
  


Reply


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


All times are GMT -5. The time now is 03:52 PM.

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