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)]                    .
 ....................................................................

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to