retrieving deleted records!

[sureshot]

Hi all of you,
Recently, i somehow deleted records from a transaction table including about millions of records in it. I have not used the truncate or optimize table command till now. I am using is 4.1.20 version. So, plz suggest some way to retrieve the deleted records?
Thanks in advance! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

When records are deleted, they are first delete-marked and finally purged by the InnoDB master thread when the records no longer exist in any active transaction's read view. After the purge, some of the deleted records would be left intact in the free lists of the B-tree index pages. But this garbage will be deleted when InnoDB reorganizes an index page or merges or splits pages to balances the B-tree. Recovering the delete-marked but not purged records is fairly easy, but restoring the purged records is hard. It is good to have backups, not only of the data files, but also the logs. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --