1, first, make sure you log whether to enable the mysql> Show variables like 'log_bin,
2, if enabled, namely ON the log files in the mysql installation directory under the data directory,
3, how to know the current log mysql> Show master status,
4, look at the binary log files using mysqlbinlog, shell> Mysqlbinlog mail - bin. 000001 or shell> Mysqlbinlog mail - bin. 000001 | tail, under Windows in a similar,


MySQL log operation:
1, first of all, after landing mysql, executing SQL statements: show variables like 'log_bin,



2, # error log log - errol open means: in my. Ini/mysqld under options: add code: the log - error=E: \ log - error. TXT,
Record content: mainly records start, run or stop the mysqld fatal problems, is a system level error record,



# 3, the query log: log, open means: in my. Ini/mysqld under options: add code: log=E:/mysql_log. TXT,



# 4, binary logs: log - bin, open means: in my. Ini/mysqld under options: add code: the log - bin=E:/mysql_log_bin, record contents: mainly records all the changes data statements, can restore the data using mysqlbinlog commands,
https://wenwen.sogou.com/z/q828320014.htm

CodePudding user response:

Thanks for sharing, it is recommended that the record in a blog post,

CodePudding user response:

Thank the bosses solutions

CodePudding user response:

Thanks for sharing, it is recommended that the record in a blog post,