mysqlcheck cron - solved

1 post / 0 new
#1 Fri, 11/11/2011 - 07:58
kenlyle

mysqlcheck cron - solved

I had: mysqlcheck -u root -p password --auto-repair --check --optimize --all-databases set to run daily.

mysqlcheck -Af -u root -p password | grep -v OK | mail -s 'MySQL Check' me@mydomain.tld set to run a few minutes later.

The email I get says: "You should give only options, no arguments at all, with option --all-databases. Please see mysqlcheck --help for more information."

A: The solution was -ppassword (no space)