Help! Deleted all mySQL rows, restore from .MYD?
I have done of the stupidest things of my life---I ran this query:delete from applicants where userid=283 or 263;
of course, 263 always evaluates to true, so I deleted everything.
Is there any way to recover? Before ending the mysql session (but after doing this stupid thing) I copied the applicants.MYD file (and .frm, and .MYI), which appears to have all the data (and also a lot of data that I deleted years ago, it seems).
Is there any way to restore it? Even partially? Please help!
Thanks,
Alex