Brogrim
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
While way beyond ny understanding I have passed my the solution on to a friend who thinks he can do it, thanks
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.
My personal bias notwithstanding, I agree with tagit.
You make me sad...
You make me sad...
ASKER
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
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/databa
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.