[Bug 296952] [NEW] mysqlhotcopy failed on table with hyphen in name

[orgoj]

Public bug reported:

In Ubuntu 8.04.1 LTS (in 8.10 seem too):

root at ns1:~# mysqlhotcopy.original --allowold tiskarna-amg /data/mysqlhotcopy
Deleting previous 'old' hotcopy directory ('/data/mysqlhotcopy/tiskarna-amg_old')
Existing hotcopy directory renamed to '/data/mysqlhotcopy/tiskarna-amg_old'
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-amg.cz_clanky READ, tiskarna-amg.cz_daystat READ, tiskarna-amg.cz_download READ' at line 1 at /usr/bin/mysqlhotcopy.original line 473.

root at ns1:~# dlocate mysqlhotcopy
mysql-server-5.0: /usr/bin/mysqlhotcopy

root at ns1:~# dpkg -l mysql-server-5.0
...
ii  mysql-server-5.0                              5.0.51a-3ubuntu5.1                            MySQL database server binaries

SOLUTION:
Comment out duplicated lines 871 and 872  "$hc_locks =~ s/\`//g;" in 8.04.1 whitch removes quotation from db/table names.

** Affects: mysql-dfsg-5.0 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
mysqlhotcopy failed on table with hyphen in name
https://bugs.launchpad.net/bugs/296952
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.