15 * * * * /usr/local/mysql/bin/mysql -u root -pxxxxxx -e 'FLUSH TABLES'

This would run a FLUSH TABLES once every hour at 15 minutes past. If you are using Windows, sorry I'm not sure how to do it there.

Easier to just set flush_time=900 in my.cnf :)
Thanks guys. Will give it a shot.


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

Reply via email to