mysqlÎóɾ
¸Õ¸ÕʹÓÃmysql£¬ÎóɾÁËtestÊý¾Ý¿â£¬»¹Ã»À´µÃ¼°±¸·Ý£»
ÔõÑù¿ÉÒÔ»Ö¸´£¿
ÓÃÊý¾Ý»Ö¸´ÎļþÊÔÊÔ
Èç¹ûÓжþ½øÖÆÈÕÖÆµÄ»°¿ÉÒԲο¼Õâ¸öÌù×ӵIJÙ×÷»Ö¸´ÄãµÄÊý¾Ý¡£
http://topic.csdn.net/u/20090608/20/e50feb34-0a07-4675-80d4-2eac35973286.html?58720
ʹÓÃmysqlbinlog»Ö¸´Êý¾Ý
²Î¿¼Ò»Ï¶þ樓°É£¬ÓÑÇé幫頂ÁË¡£
°ï¶¥
mysqlbinlog
SQL code:
[b]ÀûÓÃmysqlbinlog¹¤¾ß»Ö¸´MySQLÊý¾Ý¿â[/b]
Èç¹ûMySQL·þÎñÆ÷ÆôÓÃÁ˶þ½øÖÆÈÕÖ¾£¬Äã¿ÉÒÔʹÓÃmysqlbinlog¹¤¾ßÀ´»Ö¸´´ÓÖ¸¶¨µÄʱ¼äµã¿ªÊ¼ (ÀýÈ磬´ÓÄã×îºóÒ»´Î±¸·Ý)Ö±µ½ÏÖÔÚ»òÁíÒ»¸öÖ¸¶¨µÄʱ¼äµãµÄÊý¾Ý¡£¹ØÓÚÆôÓöþ½øÖÆÈÕÖ¾µÄÐÅÏ¢£¬²Î¼û5.11.3½Ú£¬¡°¶þ½øÖÆÈÕÖ¾¡±¡£¶ÔÓÚ mysqlbinlogµÄÏêϸÐÅÏ¢£¬²Î¼ûmysqlÊÖ²á8.6½Ú£¬¡°mysqlbinlog£ºÓÃÓÚ´¦Àí¶þ½øÖÆÈÕÖ¾ÎļþµÄʵÓù¤¾ß¡±¡£ ÒªÏë´Ó¶þ½øÖÆÈÕÖ¾»Ö¸´Êý¾Ý£¬ÄãÐèÒªÖªµÀµ±Ç°¶þ½øÖÆÈÕÖ¾ÎļþµÄ·¾¶ºÍÎļþÃû¡£Ò»°ã¿ÉÒÔ´ÓÑ¡ÏîÎļþ(¼´my.cnf or my.ini£¬È¡¾öÓÚÄãµÄϵͳ)ÖÐÕÒµ½Â·¾¶¡£Èç¹ûδ°üº¬ÔÚÑ¡ÏîÎļþÖУ¬µ±·þÎñÆ÷Æô¶¯Ê±£¬¿ÉÒÔÔÚÃüÁîÐÐÖÐÒÔÑ¡ÏîµÄÐÎʽ¸ø³ö¡£ÆôÓöþ½øÖÆÈÕÖ¾µÄÑ¡ÏîΪ-- log-bin¡£ÒªÏëÈ·¶¨µ±Ç°µÄ¶þ½øÖÆÈÕÖ¾ÎļþµÄÎļþÃû£¬
ÊäÈëÏÂÃæµÄMySQLÓï¾ä£º
SHOW BINLOG EVENTS G
Ä㻹¿ÉÒÔ´ÓÃüÁîÐÐÊäÈëÏÂÃæµÄÄÚÈÝ£º
mysql --user=root -pmy_pwd -e 'SHOW BINLOG EVENTS G'
½«ÃÜÂëmy_pwdÌæ»»Îª·þÎñÆ÷µÄrootÃÜÂë¡£
1. Ö¸¶¨»Ö¸´Ê±¼ä
¶ÔÓÚMySQL 4.1.4£¬¿ÉÒÔÔÚmysqlbinlogÓï¾äÖÐͨ¹ý--start-dateºÍ--stop-dateÑ¡ÏîÖ¸¶¨DATETIME¸ñʽµÄÆðֹʱ¼ä¡£¾ÙÀý˵Ã÷£¬¼ÙÉèÔÚ½ñÌìÉÏÎç10:00(½ñÌìÊ
Ïà¹ØÎÊ´ð£º
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
Èç¹ûÎÒÊäÈëÒ»¸ö¹Ø¼ü×Ö,Èç¹ûÓÐÒ»¸ö¹¤¾ß,¿ÉÒÔÔÚÖ¸¶¨Êýé§¿âÖвéѰËùÓÐ±í²¢ÁгöÕÒµ½µÄ½á¹û,
²»ÖªµÀÓÐûÓÐÕâÖÖÀàÐ͵ÄMYSQL Êý¾Ý¿â¹¤¾ß
û¿´¶®ÄãдµÄ
ÍÆ¼ö¸ö
MySQLQueryBrowser
phpMyAdmin£¬MySQL GU ......
±í½á¹¹ÈçÏ£º
begin_ip end_ip add1 add2
------------------- ......