mysqlhotcopy fails with invalid db/table name (patch included)

[Thomas Babut]

Binary package hint: mysql-server-5.0

The tool mysqlhotcopy is broken in the default installation of mysql-server-5.0:

# mysqlhotcopy -n -S /var/run/mysqld/mysqld.sock mysql /tmp
Invalid db.table name 'mysql.mysql`.`columns_priv' at /usr/bin/mysqlhotcopy line 860.

This problem is also reported in the debian BTS:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=440507

With the patch supplied in the debian bug report mysqlhotcopy works.

This bug is also reported on bugs.mysql.com:
http://bugs.mysql.com/bug.php?id=27303

It seems to be depending on the libdbi-perl package version and is causing problems with newer versions.

In my opinion this bug is critical, because mysqlhotcopy in this stage is useless.

[Thomas Babut (thbabut)]

I forgot to tell, which ubuntu/mysql version is affected for me. I am using Ubuntu 7.10.

Package versions:
mysql-server-5.0, 5.0.45-1ubuntu3
libdbi-perl, 1.57-1

[Thomas Babut (thbabut)]

Any news about this? This should get fixed, although there is a known workaround.

[Chuck Short (zulcss)]

I was able to reproduce this in hardy so I will get the patch in soon.

Regards
chuck

[Launchpad Janitor (janitor)]

This bug was fixed in the package mysql-dfsg-5.0 - 5.0.51-3ubuntu1

---------------
mysql-dfsg-5.0 (5.0.51-3ubuntu1) hardy; urgency=low

  [Mathias Gug]
  * Merge from debian unstable, remaining changes:
    - debian/control:
      - Set Maintainer to Ubuntu Core dev. Move Debian maintainer
        to XSBC-Original-Maintainer.
      - Add mysql-doc-5.0 as a Suggests to mysql-client-5.0, mysql-server-5.0
        and libmysqlclient15-dev.
    - debian/rules: Apply same configuration options on lpia as for i386.
  * debian/control:
    - Preprend XS-Original- to Vcs-{Browser,Svn}.
  * debian/rules:
    - Support DEB_BUILD_OPTIONS option 'nocheck' to skip tests.
  * Dropped patches:
    - debian/patches/91_bug29389.dpatch:
        fix for mysql bug 27383 which causes mysql-test 'mysql_client_test'
        to fail due to gcc 4.x optimizations.
    - debian/libmysqlclient15-dev.files, debian/mysql-client-5.0.files,
      debian/mysql-server-5.0.files: man pages are GPLed now.
  * Improved error message when unable to connect using debian-sys-maint. (LP:
    #153868)

  [Chuck Short]
  * Replcaed --with-comment="Debian" with --with-comment="Ubuntu" in debian/rules (LP: #134384)
  * Added note about the "/etc/mysql/conf.d" directory in my.cnf (LP: #136225)
  * Fixed mysqlhotcopy failure. (LP: #162393)
  * Fixed mysqlslowdump usage. Added patch from Arnold Daniels <email address hidden>. (LP: #183762)

 -- Mathias Gug <email address hidden> Fri, 25 Jan 2008 04:10:49 -0500