AutoMySQLBackup

Discussion in 'HOWTO-Related Questions' started by kpm, May 19, 2009.

  1. kpm

    kpm New Member

    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
     
  2. kpm

    kpm New Member

    solved

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

Share This Page