Hi Luis,
I've made a small script to do this, it's in the 'backing up mysql
databases' on http://www.control-alt-del.org/code
Basically, you probably want to save the binary logs by archiving
them (in case of a database crash). On a binary log I get about
60-80% compression ratios, so it's worth
On Wed, Jul 07, 2004 at 07:42:46PM +0200, Luis Mediero wrote:
> Hi,
>
> I would like write a script to purge every nigth the master log with a cron
> process. I need do it every nigth after load a lot of data into the master.
> I know if i do 'show master status' i can see the file_name of t
We delete all binlogs over 7 days old.
We figure that if a slave gets that far behind, it is easier and faster to
restore last nights master backup and edit the master.info file on the
slave to
point to todays log file.
Luis Mediero wrote:
Hi,
I would like write a script to purge every ni
