[debian-mysql] Bug#568498: mysql-server-5.1: Unable to backup db with '-' in name with mysqlhotcopy

[Libor Klepáč]

Package: mysql-server-5.1
Version: 5.1.43-1
Severity: important

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,
I have upgraded mysql from 5.0.84? to 5.1.43 today and now, I'm unable to backup databases with - in name using mysqlhotcopy.
For example db named test-test is now saved in directory /var/lib/mysql/test at 002dtest
Running 
/usr/bin/mysqlhotcopy test-test /tmp/x/nAgJGLdC
results in
Cannot open dir '/var/lib/mysql/test-test': No such file or directory at /usr/bin/mysqlhotcopy line 289.

Running
/usr/bin/mysqlhotcopy test at 002dtest /tmp/x/nAgJGLdC
results in
Unable to retrieve list of tables in test at 002dtest: DBD::mysql::db selectall_arrayref failed: Unknown database 'test at 002dtest' at /usr/bin/mysqlhotcopy line 775.
No tables to hot-copy at /usr/bin/mysqlhotcopy line 380.

Is there some solution?

With regards
Libor


- -- System Information:
Debian Release: squeeze/sid
  APT prefers experimental
  APT policy: (700, 'experimental'), (700, 'unstable'), (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32-bfs311-bfs311 (SMP w/2 CPU cores; PREEMPT)
Locale: LANG=cs_CZ.UTF-8, LC_CTYPE=cs_CZ.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mysql-server-5.1 depends on:
ii  adduser                 3.112            add and remove users and groups
ii  debconf [debconf-2.0]   1.5.28           Debian configuration management sy
ii  libc6                   2.10.2-5         Embedded GNU C Library: Shared lib
ii  libdbi-perl             1.609-1          Perl Database Interface (DBI)
ii  libgcc1                 1:4.5-20100202-1 GCC support library
ii  libmysqlclient16        5.1.43-1         MySQL database client library
ii  libstdc++6              4.5-20100202-1   The GNU Standard C++ Library v3
ii  libwrap0                7.6.q-18         Wietse Venema's TCP wrappers libra
ii  lsb-base                3.2-23           Linux Standard Base 3.2 init scrip
ii  mysql-client-5.1        5.1.43-1         MySQL database client binaries
ii  mysql-common            5.1.43-1         MySQL database common files (e.g. 
ii  passwd                  1:4.1.4.2-1      change and administer password and
ii  perl                    5.10.1-10        Larry Wall's Practical Extraction 
ii  psmisc                  22.10-1          utilities that use the proc file s
ii  zlib1g                  1:1.2.3.5.dfsg-1 compression library - runtime

Versions of packages mysql-server-5.1 recommends:
ii  bsd-mailx [mailx]  8.1.2-0.20090911cvs-2 simple mail user agent
ii  libhtml-template-p 2.9-1                 HTML::Template : A module for usin

Versions of packages mysql-server-5.1 suggests:
pn  tinyca                        <none>     (no description available)

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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAktrzowACgkQhMrxGRe1HmGewACeIdfeuhrulr2fa0vkARvV3cRl
qPIAoJLhx+5KiNRlU631W5PLsvlzMuvA
=NvPg
-----END PGP SIGNATURE-----