Chủ đề: Cronjob Automatically Optimize And Repair MySQL Databases

Creat file repair.sh with content:

Mã:

#!/bin/sh
mysqlcheck -u USERNAME -pPASSWORD --optimize --auto-repair DATABASE_NAME

Run /home/user/public_html/repair.sh at 0h and 12h, every day with cronjob:

Mã:

0 0,12 * * * * bash /home/user/public_html/repair.sh

Wish you success!