manual deletion of binary log files

2006-03-03 Thread Rithish Saralaya 
Hello.

Can I delete off the binary log files manually? I do not want to 'RESET
MASTER', as it will clear all the binary logs, and that's not what I want to
do. The database is backed up every midnight, and I wouldn't want to keep
any of the bin logs except the latest one.

We are on RHEL - MySQL 4.1.11 - INNoDB storage engine.

Regards,
Rithish.

RE: manual deletion of binary log files

2006-03-03 Thread Ryan Stille 
Yes, look at the PURGE LOGS command.

Rithish Saralaya wrote:
 Hello.
 
 Can I delete off the binary log files manually? I do not want
 to 'RESET MASTER', as it will clear all the binary logs, and
 that's not what I want to do. The database is backed up every
 midnight, and I wouldn't want to keep any of the bin logs except the
 latest one. 
 
 We are on RHEL - MySQL 4.1.11 - INNoDB storage engine.
 
 Regards,
 Rithish.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]