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 [email protected] 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: -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
