My data in a Mysql table was cleaned by somebody, and I want to catch him.By analyzing the binlog file I found this info:
# at 93029280
# 170904 13:30:54 server id 1 end_log_pos 93029379 Query thread_id=26112 exec_time=0 error_code=0
SET TIMESTAMP=1504503054/*!*/;
TRUNCATE TABLE JTZRZ_FWDJ_DJJL
/*!*/;
However I don't know what to do then. Can I get the executor ip address by the thread_id? Or anything else, help me please. Thanks a lot.