List:General Discussion« Previous MessageNext Message »
From:David (SST - Adelaide) Logan Date:August 4 2006 5:14am
Subject:RE: I have 972 vmware-bin.000XXX files!
View as plain text  
Hi Daevid,

There are the binary logs. Yes they are used for replication or you can use them much the
same as a logical log exists in some other technologies.

You can find a good description of them at the mysql manual website at : 

http://dev.mysql.com/doc/refman/5.0/en/binary-log.html 

Regards


---------------------------------------------------------------
********** _/     **********  David Logan 
*******   _/         *******  ITO Delivery Specialist - Database
*****    _/            *****  Hewlett-Packard Australia Ltd
****    _/_/_/  _/_/_/  ****  E-Mail: david.logan@stripped
****   _/  _/  _/  _/   ****  Desk:   +618 8408 4273
****  _/  _/  _/_/_/    ****  Mobile: 0417 268 665
*****        _/       ******    
******      _/      ********  Postal: 148 Frome Street,
********   _/     **********          Adelaide SA 5001
                                      Australia 
i    n    v    e    n    t                                   
---------------------------------------------------------------

-----Original Message-----
From: Daevid Vincent [mailto:daevid@stripped] 
Sent: Friday, 4 August 2006 12:43 PM
To: mysql@stripped
Subject: I have 972 vmware-bin.000XXX files!

I use a VMware for LAMP development work. 

I just looked in my /var/lib/mysql dir and there are 972 of these
vmware-bin.000001 ... vmware-bin.000972 files! Yipes!

Do I need them? Can I delete them? How do I prevent them from being created
all the time?

Can't they all just go into one vmware-bin file (as in append, like a .log
file does)?

I saw this post, but it doesn't answer any questions:
http://forums.mysql.com/read.php?28,74385,74385

Googling for 'mysql bin.000001' seems to indicate these are related to
replication -- I'm not using replication.

ÐÆ5ÏÐ 

P.S. I found this link:
http://miniprep.caltech.edu/~remote/blog/?p=99
Which says to run "reset master;" -- which did get rid of them for now, but
my questions above are still valid.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
I have 972 vmware-bin.000XXX files!Daevid Vincent4 Aug
RE: I have 972 vmware-bin.000XXX files!SST - Adelaide)4 Aug