2011/11/14 18:01 +, Rob Tanner
So what are those files and can I delete all but the most recent?
And if you look up replication, as others already have said, you will find that
the command reset master will do just that--if, as Harald hinted, you really
_want_ replication, or at least
2011/11/14 18:01 +, Rob Tanner
So what are those files and can I delete all but the most recent?
And if you look up replication, as others already have said, you will find that
the command purge binary logs to 'mysql-bin.' will do just that--if, as
Harald hinted, you really _want_
Hi,
In my MySQL directory, I have more than a few gig and a half sized files,
mysql-bin.01, mysql-bin.01 and et cetera. They date from today all the
way back to early 2010. I don't know exactly what those files are but I would
like to delete as many as are no longer is use since I
Am 14.11.2011 19:01, schrieb Rob Tanner:
In my MySQL directory, I have more than a few gig and a half sized files,
mysql-bin.01,
mysql-bin.01 and et cetera. They date from today all the way back to
early 2010.
I don't know exactly what those files are but I would like to
Those are your binary logs. They store the data stream to be consumed
by your slaves.
.http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
Are you using replication? If so, you need to go to each of your
slaves and run the command 'SHOW MASTER STATUS;'. That will tell you
which files are
If you search on mysql-bin.01 you get a lot of good info.
o They are mysql log files it contains all the queries u can view
these files with the command mysqlbinlog just man it for more details
o These are your binary log files.. you might not want to switch them
off depending on your setup -
The binary log is useful for more then just replication and can be used to
take incremental backups or to perform forensics on what your server has
done. I would recommend learning how to use them to your advantage over
turning binary logging off as some have recommended. Make sure you're