FYI
We had been testing RackTables on a SME v9 box.
We were using SCL MySQL 5.5
We run automysqlbackup and we noticed that it started throwing an error:
mysqldump: Couldn't execute 'show create table `Location`': SHOW VIEW command denied to user 'backupuser'@'localhost' for table 'Location' (1142)
Not helpful as it doesn't tell you the offending DB.
After hunting a bit we realised it was the RackTables DB.
The cure was to add the SHOW VIEW permission to the backup user
The SQL taken from phpmyadmin that does this is:
REVOKE ALL PRIVILEGES ON * . * FROM 'backupuser'@'localhost';
REVOKE GRANT OPTION ON * . * FROM 'backupuser'@'localhost';
GRANT SELECT ,
LOCK TABLES , EVENT,
SHOW VIEW ON * . * TO 'backupuser'@'localhost';
And fixed.