I can confirm this is still an issue.  Deckard's solution helped, but it
only looks at the DBEXCLUDE parameter if you are also setting the
configuration parameter DBNAMES line to "all" in the
/etc/default/automysqlbackup file.

By default, the configuration file has these defaults:

 DBNAMES=`mysql --defaults-file=/etc/mysql/debian.cnf --execute="SHOW
DATABASES" | awk '{print $1}' | grep -v ^Database$ | grep -v ^mysql$ |
tr \\\r\\\n ,\ `

 DBEXCLUDE="information_schema"

They could be changed to this to fix the issue:

 DBNAMES="all"

 DBEXCLUDE="information_schema performance_schema"

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/995587

Title:
  mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user
  'debian-sys-maint'@'localhost' for table 'cond_instances' when using
  LOCK TABLES

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/automysqlbackup/+bug/995587/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to