ServerTune Knowledgebase | / I see hundreds of mysql-bin.00xxxxxxx files in /var/lib/mysql directory. What are these files?

I see hundreds of mysql-bin.00xxxxxxx files in /var/lib/mysql directory. What are these files?

	Printer friendly
	Email to friend
	Add comment

Views: 1454 Votes: 1 Comments: 0
Posted: 04 Jun, 2007 by: Customer Service :: S. * * * * * Updated: 04 Jun, 2007 by: Customer Service :: S.

These files are created when you fail to turn log-bin off for MySQL (needed if you allow off-site MySQL servers). SSH to the server and edit /etc/my.cnf file, and add this directive:
# LOG-BIN

If you do not allow other servers to access MySQL to this server, you can safely delete all of these files.

Other articles in this Category

	Starting MySQLCouldn't find MySQL manager or server
	How can I check if query cache is working on my MySQL server?
	HowTo :: commands, statements, and clauses
	HowTo :: change MySQL root password
	Got a packet bigger than 'max_allowed_packet' bytes
	MySQL :: HowTo fix Access-Denied Errors
	Warning: MySQL server has gone away
	Error :: Can't connect to [local] MySQL server
	Who is exhausting MySQL resources on my server?