Hello.
See:
http://dev.mysql.com/doc/mysql/en/binary-log.html
Philippe de Rochambeau <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: US-ASCII, 25 lines --]
>
> Hello,
>
> my /var/lib/mysql directory contains many -bin.xxx files, some of
> which date back t
Kevin Cowley
R&D
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
> - to remove the bin logs:
>
> PURGE MASTER LOGS TO 'filename'; (where filename is the
> name of the last bin log to keep)
I prefer RESET MASTER - it clears and delete
Philippe de Rochambeau wrote:
my /var/lib/mysql directory contains many -bin.xxx files, some of
which date back to October 2004. What exactly are these files? Can I
safely remove the older ones?
- these are the bin logs, used in replication. MySQL writes all INSERT,
UPDATE, etc., and DDL co
Hello,
my /var/lib/mysql directory contains many -bin.xxx files, some of
which date back to October 2004. What exactly are these files? Can I
safely remove the older ones?
Many thanks.
Philippe
-rw-rw1 mysqlmysql1073741948 Oct 16 15:00
/var/lib/mysql/mydb-bin.029
-rw-rw
