CRON Repair optimize tables 3.5.4
 

Was wondering if someone could tell me how i would go about setting up repar/optimize tables as a cron job for 3.5.4. I didnt want to download the database backup pro hack for 3.0 for a couple reasons - one being that it backs up ur database..... I just wanna run repair/optimize tables like once a week. Im going away for about 2 months to a third world country and i dont imagine i will have time to do my weekly repair optimize tables.....
any help would be greatly appreciated.

Its not really nessary to run a optmize now and then I'd be more worried about it needing a repair, however I dont believe the cron system (at least not the vB one) is going to get the job done.

If you have SSH/cron access you can setup a nightly repair on the database via mysqlcheck or myisamcheck which would get the job done better.

There is no technical reason you could not use the vb cron system, it's only running (a lot) of SQL commands, no different to running a select or update. I would question why you want to do this. Unless a table is broken then there is no need to run a repair on it, and there is no real need to optimise tables on a regular basis.

The reason why you wouldnt want the vbcron system running repairs is.. what happens if the cron table breaks? or the usertable. the tasks are going to stop running. Thats why it'd be better to use the systems cron.

im no pro at this but my board actually runs a lot faster when i repair/optimize

I'm not a sql pro...but same here...One and a half million posts...huge daily overhead in several tables (megabytes)...after optimization somehow it runs much smoother.

SERIOUSLY.
The improvement in speed on my site is drastically changed when I do a repair and optimize.
I know it's not recommended, but can someone just tell me how I can do an automatic "repair and optimize database" about 4 times a day?

I would also0 REALLY really appreciate it if someone could tell me how to do an auto database backup every two days of my whole database to my server that overwrites the old file.

Thanks in advance professionals.

Unless you are mass deleting threads and attachments on a daily basis there is no real reason for an optmize to bring a large speed up.

There is a mod for this that does a nightly optmization.

ummmmmmmmmmm?