> Note that you should not just delete the bin logs. Instead 
> use PURGE MASTER LOGS. See 
> http://dev.mysql.com/doc/refman/4.1/en/purge-master-logs.html
> 
> hth,
> mark


Sorry, accidently hit Ctrl/Enter :(

Anyway, I can't purge with that command:

mysql> PURGE MASTER LOGS TO 'mysql-bin.023';
ERROR: 
A purgeable log is in use, will not purge

Any ideas?  I'm tempted to just delete but would prefer to do this the right
way, and for some reason it thinks they are in use :/.  I'm showing:


mysql> show master status;                 
+----------+-----------+--------------+------------------+
| File     | Position  | Binlog_do_db | Binlog_ignore_db |
+----------+-----------+--------------+------------------+
| repl.024 | 110962544 |              |                  |
+----------+-----------+--------------+------------------+
1 row in set (0.00 sec)

Thanks,
Warren


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

Reply via email to