MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Bastian Balthazar Bux Date:June 9 2005 10:59am
Subject:Re: xxx-bin.0000xxx files
View as plain text  
Philippe de Rochambeau wrote:
> My version of mysql creates all sorts of xxx-bin.0000xxx files in the
> /var/lib/mysql directory. I regularly remove the oldest files for space
> purposes.
> 
> What exactly are these files and what is the proper way to manage them?
> 
> Thanks.
> 
> Philippe
> 
> 
> 
If you don't need them comment out the "log-bin" directive in "[mysqld]"
section of "my.cnf" config file.

To remove them a "PURGE MASTER LOGS" or "RESET MASTER" query is better
than remove them by hand.

For more information on binary logs have a look at
http://dev.mysql.com/doc/mysql/en/binary-log.html
official MySQL documentation.

Regards
Francesco

-- 
 ....................................................................
. These pages are best viewed by coming to my house and looking at   .
. my monitor. [S. Lucas Bergman (on his website)]                    .
 ....................................................................
Thread
xxx-bin.0000xxx filesPhilippe de Rochambeau9 Jun
  • Re: xxx-bin.0000xxx filesBastian Balthazar Bux9 Jun