[debian-mysql] Bug#735014: mysql-server-5.5: mysqlhotcopy fails on cond_instances in performance_schema

[Paul Szabo]

Package: mysql-server-5.5
Version: 5.5.33+dfsg-0+wheezy1
Severity: normal

Dear Maintainer,

I am in the habit of using  mysqlhotcopy  for backup, something like
  mysqlhotcopy "--regex=.*" ./tmp
After the upgrade from squeeze to wheezy (mysqlserver-5.1 to 5.5), that
fails with error
  DBD::mysql::db do failed:  command denied to user 'root'@'localhost' for table 'cond_instances' at /usr/bin/mysqlhotcopy line 520.
Googling for similar, I came across
http://bugs.mysql.com/bug.php?id=61414
that says to skip database
  performance_schema
(as well as information_schema already skipped in mysqlhotcopy).

The following one-line patch seems to have solved the problem for me.

Cheers, Paul

Paul Szabo   psz at maths.usyd.edu.au   http://www.maths.usyd.edu.au/u/psz/
School of Mathematics and Statistics   University of Sydney    Australia


--- /usr/bin/mysqlhotcopy.bak	2013-12-15 10:00:06.000000000 +1100
+++ /usr/bin/mysqlhotcopy	2014-01-11 17:09:34.000000000 +1100
@@ -268,6 +268,7 @@
     $sth_dbs->execute;
     while ( my ($db_name) = $sth_dbs->fetchrow_array ) {
 	next if $db_name =~ m/^information_schema$/i;
+	next if $db_name =~ m/^performance_schema$/i;
 	push @db_desc, { 'src' => $db_name, 't_regex' => $t_regex } if ( $db_name =~ m/$opt{regexp}/o );
     }
 }


-- System Information:
Debian Release: 7.3
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 3.2.51-pk06.19-i386 (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.5 depends on:
ii  adduser                3.113+nmu3
ii  debconf [debconf-2.0]  1.5.49
ii  initscripts            2.88dsf-41+deb7u1
ii  libc6                  2.13-38
ii  libdbi-perl            1.622-1
ii  libgcc1                1:4.7.2-5
ii  libstdc++6             4.7.2-5
ii  lsb-base               4.1+Debian8+deb7u1
ii  mysql-client-5.5       5.5.33+dfsg-0+wheezy1
ii  mysql-common           5.5.33+dfsg-0+wheezy1
ii  mysql-server-core-5.5  5.5.33+dfsg-0+wheezy1
ii  passwd                 1:4.1.5.1-1
ii  perl                   5.14.2-21+deb7u1
ii  psmisc                 22.19-1+deb7u1
ii  zlib1g                 1:1.2.7.dfsg-13

Versions of packages mysql-server-5.5 recommends:
ii  bsd-mailx [mailx]      8.1.2-0.20111106cvs-1
ii  libhtml-template-perl  2.91-1

Versions of packages mysql-server-5.5 suggests:
pn  tinyca  <none>

-- debconf information:
  mysql-server-5.5/postrm_remove_databases: false
  mysql-server/error_setting_password:
  mysql-server-5.5/nis_warning:
  mysql-server-5.5/really_downgrade: false
  mysql-server-5.5/start_on_boot: true
  mysql-server/password_mismatch:
  mysql-server/no_upgrade_when_using_ndb: