-bin files.
Question: is this normal ? If not, how can I avoid these mysql-bin files ?
When using MySQL Administrator to look at a mysql-bin file, it shows only:
060330 8:29:00 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt:
ready for connections.
Version: '5.0.15-nt-log
inputfiles, I get about 2.5 GB of mysql-bin files.
Question: is this normal ? If not, how can I avoid these mysql-bin files ?
When using MySQL Administrator to look at a mysql-bin file, it shows only:
060330 8:29:00 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt:
ready
: LOAD DATA giving BIG mysql-bin files ...
I think this is normal as the binary log will contain a record of all
changes made to the data, therefore if you are loading large files
regularly- the bin logs will be quite large. If you do not want the binary
logging, edit the my.cnf file, comment out
Hello,
I am new to mysql and am in the middle of upgrading our mysql server to the
latest release. Upon viewing our currently
data directory I noticed a large amount of hostname-bin-### files.
Some of hostname-bin-### have time stamps of January -- from the documentation I have
read I
Are you running the server with the log-bin option? If you do not need these
for restoration and or backup purposes you can purge these files.
-Original Message-
From: Michael Gale
To: [EMAIL PROTECTED]
Sent: 8/3/04 12:16 PM
Subject: mysql bin files
Hello,
I am new to mysql
On Tue, Aug 03, 2004 at 11:16:43AM -0600, Michael Gale wrote:
Hello,
I am new to mysql and am in the middle of upgrading our mysql
server to the latest release. Upon viewing our currently data
directory I noticed a large amount of hostname-bin-### files.
Some of hostname-bin-###