PHP群:95885625 Hbuilder+MUI群:81989597 站长QQ:634381967
    您现在的位置: 首页 > 数据库 > MySQL教程 > 正文

    开启和查看mysql的bin-log日志

    作者:admin来源:网络浏览:时间:2018-03-14 00:16:48我要评论
    分享到
    导读:[root@VM_0_7_centos data]# vim /etc/my.cnf [root@VM_0_7_centos data]# vim /etc/my.cnf [root@VM_0_7_centos data]# /etc/in...
    [root@VM_0_7_centos data]# vim /etc/my.cnf
    [root@VM_0_7_centos data]# vim /etc/my.cnf 
    [root@VM_0_7_centos data]# /etc/init.d/mysqld restart
    Shutting down MySQL.... SUCCESS! 
    Starting MySQL. SUCCESS! 
    [root@VM_0_7_centos data]# grep log_bin /etc/my.cnf 
    [root@VM_0_7_centos data]# grep log-bin /etc/my.cnf 
    log-bin=/opt/mysql/data/mysql-bin
    mysql> show variables like '%log_bin%';
    ERROR 2006 (HY000): MySQL server has gone away
    No connection. Trying to reconnect...
    Connection id:    2
    Current database: wordpress
    
    +---------------------------------+---------------------------------+
    | Variable_name                   | Value                           |
    +---------------------------------+---------------------------------+
    | log_bin                         | ON                              |
    | log_bin_basename                | /opt/mysql/data/mysql-bin       |
    | log_bin_index                   | /opt/mysql/data/mysql-bin.index |
    | log_bin_trust_function_creators | OFF                             |
    | log_bin_use_v1_row_events       | OFF                             |
    | sql_log_bin                     | ON                              |
    +---------------------------------+---------------------------------+
    6 rows in set (0.01 sec)
    
    
    开启和查看mysql的bin-log日志  

    转载请注明(B5教程网)原文链接:http://www.bcty365.com/content-35-6232-1.html
    相关热词搜索:
    网友评论: