Hi, I've got automysqlbackup running (http://www.howtoforge.com/creating-mysql-backups-with-automysqlbackup) 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
solved 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;