By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,977 Members | 1,352 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,977 IT Pros & Developers. It's quick & easy.

Flush logs, binary log index file

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.