#1  
Old 19th May 2009, 01:06
kpm kpm is offline
Junior Member
 
Join Date: Nov 2008
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default AutoMySQLBackup

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
Reply With Quote
Sponsored Links
  #2  
Old 19th May 2009, 02:18
kpm kpm is offline
Junior Member
 
Join Date: Nov 2008
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default solved

Quote:
Originally Posted by kpm View Post
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;
Reply With Quote
Reply

Bookmarks

Tags
automysqlbackup

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
replacement for mysqldump --all-databases sjau Programming/Scripts 14 21st June 2011 15:25


All times are GMT +2. The time now is 05:14.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.