According to the bin log analysis administrator was inexplicably deleted problem =============== according to the bin log analysis administrator was inexplicably deleted problem www.2cto.com # at 88572251 #120907 7:45:34 server id 1 end_log_pos 88572346 Query thread_id = 32426664 exec_time = 0 error_code = 0 set timestamp = 1346975134 /*! */; Delete from admin WHERE id = 62 /*! */; # At 88572346 #120907 7:45:34 server id 1 end_log_pos 88572418 Query thread_id = 32426664 exec_time = 0 error_code = 0 set timestamp = 1346975134 /*! */; COMMIT /*! */; # At 88572418 www.2cto.com #120907 7:45:34 server id 1 end_log_pos 88572489 Query thread_id = 32426664 exec_time = 0 error_code = 0 set timestamp = 1346975134 /*! */; BEGIN /*! */; # At 88572489 #120907 7:45:34 server id 1 end_log_pos 88572591 Query thread_id = 32426664 exec_time = 0 error_code = 0 set timestamp = 1346975134 /*! */; Delete from corp_db WHERE corp_id = 62 /*! */; # At 88572591 #120907 7:45:34 server id 1 end_log_pos 88572618 Xid = 132059217 COMMIT /*! */; # At 88572618 #120907 7:45:34 server id 1 end_log_pos 88572689 Query thread_id = 32426664 exec_time = 0 error_code = 0 set timestamp = 1346975134 /*! */; BEGIN /*! */; You can see the SQL operation in the context of DELETE FROM admin WHERE id = 62, delete from corp_db WHERE corp_id = 62 should have caused a bug in the delete from admin code when deleting the company.