Tuesday, July 30, 2013

Mysqloptimize chokes when you have dots in database or table names

After digging a bit, and having google throw up useless bits, I finally tracked down my mysqloptimize error that had crept into my daily admin email.

The error starts off:

mysqloptimize: Got error: 1064

The problem was in my database and table names. Once I got rid of the periods in both, the optimize command works like a champ.