Re: handling mysql binlog data

2008-05-03 Thread Matthew Seaman
Zbigniew Szalbot wrote: Will any future upgrade (by means of portupgrade) not change the custom mysql location back to /var/db/mysql? Not if you set: mysql_dbdir="/usr/mysql" in /etc/rc.conf Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory

Re: handling mysql binlog data

2008-05-02 Thread Chris Pratt
On May 2, 2008, at 9:28 AM, Zbigniew Szalbot wrote: Hi Chris, Chris Pratt pisze: Thank you anyway - this was very helpful and I instantly saved a lot of space on a shrinking /var partition! I find it most comfortable to do this manually so I can check my backups first. There is an examp

Re: handling mysql binlog data

2008-05-02 Thread Zbigniew Szalbot
Hi Chris, Chris Pratt pisze: Thank you anyway - this was very helpful and I instantly saved a lot of space on a shrinking /var partition! I find it most comfortable to do this manually so I can check my backups first. There is an example in the reply comments below the documentation on the

Re: handling mysql binlog data

2008-05-02 Thread Chris Pratt
On May 2, 2008, at 8:58 AM, Zbigniew Szalbot wrote: The procedure for this is here: http://dev.mysql.com/doc/refman/5.1/en/purge-master-logs.html for 5.1 and here: http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html for 5.0 Thanks a lot! It did help me get rid of a few files in a

Re: handling mysql binlog data

2008-05-02 Thread Zbigniew Szalbot
Hello, Chris Pratt pisze: On May 2, 2008, at 5:27 AM, Zbigniew Szalbot wrote: Hello, Following a recent thread I would like to ask if it is safe to remove old binlog data. From the below I understand that the current binlog is mysql-bin.07 and the previous ones (from 01-06)

Re: handling mysql binlog data

2008-05-02 Thread Chris Pratt
On May 2, 2008, at 5:27 AM, Zbigniew Szalbot wrote: Hello, Following a recent thread I would like to ask if it is safe to remove old binlog data. From the below I understand that the current binlog is mysql-bin.07 and the previous ones (from 01-06) are not written to any more

Re: handling mysql binlog data

2008-05-02 Thread Matthew Seaman
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Zbigniew Szalbot wrote: > Hello, > > Following a recent thread I would like to ask if it is safe to remove > old binlog data. From the below I understand that the current binlog is > mysql-bin.07 and the previous ones (from 01-06) are