I have a mysql server and while working on it I accidentlly truncated the wrong table. I do have a mysql dump wich I immediately used to restore my database structure, but I still miss some entries in only one table.
SHOW BINARY LOGS shows me 64 logs.
How do I know wich log to restore and what is the procedure of restoring with mysqlbinlog? Using the last log is not changing anything ...
EDIT: I already checked http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html but didn't accomplish anything
Would it be enough to just manually search all logs for the needed insert statements?
Thank you Soda