Re: mysql-bin.00000X

2006-08-30 Thread Chris
Tanner Postert wrote: there are ton of these files in my mysql data directory on fedora core 5 they are about a GB a piece. it appears that they are snapshots or some kind of log file. what is creating these files? http://dev.mysql.com/doc/refman/5.1/en/binary-log.html -- MySQL General Ma

RE: mysql-bin.00000X

2006-08-30 Thread Logan, David (SST - Adelaide)
Hi Tanner, These are the binary logs. Look in your my.cnf file or check your system variable ( do this ) mysql> show variables like '%log%'; and see if you have log-bin enabled. These are generally used for recovery from the last full backup (similar to logical/redo logs in other technologies) a