469,282 Members | 1,947 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

Flush logs, binary log index file

I'm trying to write a script to weekly remove MySQL logs, the general,
error and binary log files.

Following the MySQL documentation, I've written a script that moves all
current log files, then executes mysqladmin flush-logs.

My question is this on the binary logs (bin.001, bin.002, etc.): once these
are removed and flush logs is executed, the binary log files start over
with bin.001.

HOWEVER, the binary index file does not appear affected by the flush-logs
command; ie, if I'm up to bin.003 in the binary.index file, remove the
files and execute the flush logs command, I'm back to a file names bin.001,
although the binary.index file still has entries for bin.001, bin.002,
bin.003, etc. How does the binary index file stay current when you remove
the logs??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 3941

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jean Hagen | last post: by
6 posts views Thread by paul | last post: by
6 posts views Thread by james | last post: by
1 post views Thread by nitroamos | last post: by
16 posts views Thread by vizzz | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.