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

[Andreas Olsson]

Let me see...

Previously mysqlhotcopy used "$dbh->tables()" to get a list of a
database's tables. This happens in the subroutine get_list_of_tables.
For convenience I'm attaching a mysqlhotcopy from dapper, where this
behavior can be seen.

Around DBD::mysql version 4.003 the behavior of "$dbh->tables()"
changed. Instead of returning a simple "tablename" it started to return
a full "databasename.tablename". This resulted in mysqlhotcopy trying to
operate on "databasename.databasename.tablename". That is the issue 56-*
deals with. Well, there were also some following issues of quotation.

If you look at the subroutine get_list_of_tables in a more modern
mysqlhotcopy you'll see that it get its list of tables from a SQL-query
based on "SHOW TABLES FROM...". This again returns the table list in the
simple form of "tablename", without any database-prefix.

Hence the 56-patch doesn't apply.

** Attachment added: "mysqlhotcopy.dapper"
   http://launchpadlibrarian.net/22563476/mysqlhotcopy.dapper

-- 
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.