MySQL Check

Cron this!

#!/bin/sh
#
# MySQL Check
#
NOW=$(date +"%Y-%m-%d-%H-%M-%S")
#
MYSQLPASS="yourootpassword"
#
#MySQL Check
/usr/bin/mysqlcheck -ACes -uroot --password=${MYSQLPASS}
#
exit 0

• Include option o to optimize the tables as well
• Ignore Note