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
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_ replicatio
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
monitorin
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 -
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 cu
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
