Find out who truncate my mysql important table?

741 views Asked by At

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.

0

There are 0 answers