MySQL binary log on under Linux Open

Long time no blog, the recent technical study is very few. Don't say much, go straight to the chase.

It is recently necessary to open the MySQL update log (that is, binary log) under Linux, which can be used to avoid database errors or data loss before being able to revert to the operation. But many of the online posts are copy sticky, even for several days have not set a successful. Most of the online methods are encountered, the database restart failed.

Tried a lot of methods, finally set a successful, very grateful to the author of the post of God.

MySQL query log, slow query log, error log, the online Setup method is correct. However, there is a problem with the binary log set. The correct setup method is as follows,

In the/etc/my.cnf file, under "Mysqld", add

#更新日志

Server-id = 1
Log-bin = Binlog
Log-bin-index = Binlog.index

, the statement in the red box,

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6C/75/wKioL1VJ2EzztmWHAAJwUNmWn2g257.jpg "title=" 11112. JPG "alt=" wkiol1vj2ezztmwhaajwunmwn2g257.jpg "/>

Start MySQL successfully. Attach the official God post, thank you very much

Http://www.111cn.net/database/mysql/48098.htm

This article is from "Rookie It" blog, please make sure to keep this source http://han223909.blog.51cto.com/6249236/1643497

MySQL binary log on under Linux Open