Bug #29503 mysqlhotcopy broken by DBD::mysql 4.004
Submitted: 2 Jul 2007 23:34 Modified: 17 Aug 2007 19:11
Reporter: John ORourke Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Backup Severity:S2 (Serious)
Version:1.22 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: DBD::MySQL, hot copy, tables

[2 Jul 2007 23:34] John ORourke 
Description:
The undocumented change to the DBD::mysql in 4.004 whereby the DBI->tables() method now returns "`dbname`.`tablename`" instead of "`tablename`" has broken mysqlhotcopy 1.22.

How to repeat:
--------------------------------------------commands:
perl -MCPAN -e'install DBI DBD::mysql'
mysqlhotcopy .....
--------------------------------------------gives:
Invalid db.table name 'my_database`.`my_table' at mysqlhotcopy line 854

Suggested fix:
PATCH:

839a840
>         s/.*\.//;
[3 Jul 2007 6:05] Valeriy Kravchuk 
Thank you for a bug report. Verified just as described on Linux.
[17 Aug 2007 19:11] Timothy Smith 
This is a duplicate of bug #27694