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.