Auto repair/optimize Database/Tables (cronejob)
 

Hello :)

is it possible to create a cronjob, which repair and optimize the database/tables everey x days?

Sorry for my bad english, iam german ^^

Hope anyone can help me :)

Best regards

*puhs*
No1 have an idea?

You have the unzipped files for your forum on your computer, right?

In the AdminCP folder, check the code for repair.php. Copy out the code for the "?do=dorepair" section to a new script (maybe call it cronrepair.php) then adjust to your liking.

Scheduling vB's cronjob to run this script would be done in AdminCP -> Scheduled Tasks.

Is this from line 125 to 135? (// ######################### Start do repair #####################)

Iam not the greatest coder, so i dont know exatly which lines are for this feature :)

It is not a good idea to repair your tables just for the sake of it. You should only have to repair them if their are problems.

Hello Lynne,

some peoples mean, that is better when i repair/optimize everey week. isnt it?

No. You should only repair/optimize your tables if needed. They will take care of themselves. If your database *needs* to be repaired often, then there is something wrong and you should be talking to your host.