• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

MySQL Back Up from ibdata file

I had some of my tables stored in MyISAM storage engine.

When I restored the DB it had dropped records from the MyISAM table.

I have a file on my hard drive named "ibdata" which is the exact same size as the database before it was restored.

Is there anyway I can restore the lost records from here?

Praying very hard for a positive response.
0
Brogrim
Asked:
Brogrim
  • 2
  • 2
  • 2
1 Solution
 
RobOwner (Aidellio)Commented:
Have a look here: http:Q_28268958.html
Recently helped someone restore their database
0
 
Steve BinkCommented:
While tagit's directions from the other post will generally work, you'll need other data files for MyISAM.  The ibdata file is used for the InnoDB transaction-based engine.  If your data loss came from an InnoDB table, you would certainly need that file.

For MyISAM tables, there are three files of interest for each table.  The .FRM file contains the definition, the .MDY file contains data, and the .MYI file contains the index information.  These files are held in the data subdirectory, filed under the database's name (usually /var/lib/mysql/data/database_name).

Otherwise, the same instructions apply - stop MySQL, make it use the old tables (either re-point the directory, or move the files around), start MySQL, dump what you need, revert to the current tables.
0
 
BrogrimInformation Systems Development ManagerAuthor Commented:
While way beyond ny understanding I have passed my the solution on to a friend who thinks he can do it, thanks
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
RobOwner (Aidellio)Commented:
Thanks for the points but is this really a solution? If so then routinet's comment deserves acknowledgement as this wasn't obvious in the other post.
0
 
Steve BinkCommented:
My personal bias notwithstanding, I agree with tagit.

You make me sad...
0
 
BrogrimInformation Systems Development ManagerAuthor Commented:
Sorry  routinet, I passed it on to a friend and he said he could work with it. Dont be sad a novice like me will have more points to give out
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now