Batch File?

[buzzt]

I need to frequenly run the mysqladmin flush-hosts command. It was suggested that I use a batch file to run this every 30 minutes or so. Any idea how to write one? Is there another way to have MySQL do this?

 

[sleipnir214]

MySQL does not have any functionality to perform automated tasks, if that's what you mean.

But it's a simple matter to pass commands into the mysql admin app in order to use OS-specific automation to perform MySQL housekeeping chores.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[ingresman]

try AT on nt/windows 2000 etc or cron on unix. If you are really stuck knock out a PHP page that refreshes every 30 mins in a browser that calls the flush statement.
Or a little C progrman that calls sleep() for 30 mins.

Depends on your skill/platform