微笑如一
首页 网络收藏 分解查字

浏览:886
内容:
mysql安装路径 修改:my.ini 在[mysqld]下添加 server_id=12345 log-bin=mysql-bin binlog_format=row 重启mysql服务 检查log_bin是否启动 mysql> show variables like 'log_%'; +---------------------------------+----------------------------------------------------------------+ | Variable_name | Value | +---------------------------------+----------------------------------------------------------------+ | log_bin | ON | | mysql> show binary logs; +------------------+-----------+ | Log_name | File_size | +------------------+-----------+ | mysql-bin.000001 | 107 | +------------------+-----------+ 1 row in set (0.00 sec)
联系: web@xiaoruyi.cn