ÈçºÎ²é¿´mysqlÔËÐС¢·ÃÎʼǼµÈÈÕÖ¾

1.Ê×ÏÈÈ·ÈÏÄãÈÕÖ¾ÊÇ·ñÆôÓÃÁË
mysql>show variables like 'log_bin';
mysql>show variables like 'log';
2.Èç¹ûÆôÓÃÁË£¬¼´ON
Èç¹ûûÓÐÆôÓ㬼´OFF£¬
ÒªÐÞ¸Ämy.cnf
  
  #   The   MySQL   server   
  [mysqld]   
    
  #   Uncomment   the   following   if   you   want   to   log   updates   
  log-bin  
  log 
ÄÇÈÕÖ¾Îļþ¾ÍÔÚmysqlµÄ°²×°Ä¿Â¼µÄdataĿ¼ÏÂ
3.ÔõÑùÖªµÀµ±Ç°µÄÈÕÖ¾
mysql> show master status;                                                                                                                                                4.¿´¶þ½øÖÆÈÕÖ¾ÎļþÓÃmysqlbinlog
shell>mysqlbinlog mail-bin.000001
»òÕßshell>mysqlbinlog mail-bin.000001 | tail
Windows ÏÂÓÃÀàËƵÄÃüÁî