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!