MySQL batch optimize tables ?

michaelsanford

Translator, Web Developer
I don't know enough PERL (I assume PERL is the way to go with this) to do this myself.

I'd like to run a corn job say every week that does performs an OPTIMIZE TABLE on all the dables on all the databases I have. I don't want to have to do it in phpmyadmin all the time and unfortunately mysql won't take a wildcard for that.

Any ideas ?
 
Back
Top