MySQL Forums
Forum List  »  MyISAM

Recover deleted lines
Posted by: Gerhard Gruber
Date: January 06, 2007 08:58AM

Hi all!

I have a big problem! Today I deleted all my rows from a very important database - my Mail-database.
The (hopefully) good message is, that I could rescue all Table-Files before mysqld could delete the rows. I am not sure if there are all lines rescued but very much.

So I have a question: How can I export the data-lines from the MYD-File and insert in a new Table? Or is there any tool, which could rescue the records?
When I tried to repair the table with myisamchk, the tool deleted all records from the MYD-File.

thanks
gerhard

Options: ReplyQuote


Subject
Views
Written By
Posted
Recover deleted lines
3647
January 06, 2007 08:58AM
2115
January 06, 2007 09:35AM
1941
January 07, 2007 06:15PM
1750
January 17, 2007 10:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.