Home >Database >Mysql Tutorial >Mysql Data目录生成大量mysql-bin.****_MySQL

Mysql Data目录生成大量mysql-bin.****_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:51:13985browse

Mysql Data目录生成大量mysql-bin.****

这些文件是叫做MySQL Binary Log,主要有下面两个作用:

  1. 数据恢复。
  2. 在主从服务器上提高复制的可靠性。这个其实是主要的作用,但是我根本没有主从服务器,我只有一个,所以用不着,对不?

找到my.cnf或者my.ini
#log-bin=mysql-bin
#binlog_format=mixed
这两行注释掉,然后将这些文件全部删除。

重新启动Mysql服务器。

不在彷徨,一切来源于梦想。
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn