cron job, optomize tables

[Murphinator]

my mysql is messed up, i dont really know how to fix it nor care because i will be going to a different host soon, can you tell me how i can make a cron job that will optomize the tables every hour because that seems to fix it

[miz]

write a php file that every time you run it will optimize tables
and then in admincp you can add it and the rate its will be running this file

[Murphinator]

yeah but i dont know how to make the file, which is unfortunet

[Murphinator]

anyone!

someone has got to know