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:
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
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:
perl -MCPAN -e'install DBI DBD::mysql'
mysqlhotcopy .....
Invalid db.table name 'my_database`.`my_table' at mysqlhotcopy line 854

Suggested fix:

>         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