Server Setup | Security | Performance Tuning | …

mysqlcheck

Run mysqlcheck to fix SQL index/.. errors once in a while

this can be used as a weekly cronjob, the output is sent by mail

 mysqlcheck -A -r --host=${HOST}  --user=root --port=3308 --password=${PASSWD}  | mail -s '[SQL Server] mycheck complete' $EMAILADDI

mysqldump dump a databse to a file. there are many parameters. check 'man mysqldump'

–opt is important to fix encoding!

 mysqldump --opt --host=127.0.0.1 --default-character-set=utf8 --user=root \ 
 --password=${PWD} $DB > $FILE