Public bug reported:

In Ubuntu 8.04.1 LTS (in 8.10 seem too):

[EMAIL PROTECTED]:~# 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.

[EMAIL PROTECTED]:~# dlocate mysqlhotcopy
mysql-server-5.0: /usr/bin/mysqlhotcopy

[EMAIL PROTECTED]:~# 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.

-- 
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs

Reply via email to