AutoMySQLBackup

[kpm]

Hi, I've got automysqlbackup running (http://www.howtoforge.com/creating-m...utomysqlbackup) but it is only backing up the "information_schema" db and one other db i set up called "test". Rather than list all of the databases, I edited the dbnames variable like so:
DBNAMES="all"
There are 8 other databases that are not getting backed up. The script states that one can use "all" rather than list each database. Can any one inform me as to why this may be?

Thanks

[kpm]

Originally Posted by kpm

Hi, I've got automysqlbackup running (http://www.howtoforge.com/creating-m...utomysqlbackup) but it is only backing up the "information_schema" db and one other db i set up called "test". Rather than list all of the databases, I edited the dbnames variable like so:
DBNAMES="all"
There are 8 other databases that are not getting backed up. The script states that one can use "all" rather than list each database. Can any one inform me as to why this may be?

Thanks

My mistake... needed to grant proper permissions to the backup user:
GRANT SHOW DATABASES, SELECT, LOCK TABLES, RELOAD ON *.* to backupUser@localhost
IDENTIFIED BY 'secret';
FLUSH PRIVILEGES;