MySQL Forums
Forum List  »  Backup

Recover deleted lines
Posted by: Gerhard Gruber
Date: January 05, 2007 05:30AM

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?
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
2594
January 05, 2007 05:30AM


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.