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][1]  but didn't accomplish anything

Would it be enough to just manually search all logs for the needed insert statements?

Thank you
Soda


  [1]: http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html