An example of mysqlhotcopy running error Solution

Mysqlhotcopy runs as follows:

[Root @ local_slavedb ~] # Mysqlhotcopy test/tmp

Invalid db. table name 'test. test'. 'mytest' at/usr/bin/mysqlhotcopy line 855.

Solution:

Suggested fix:

A quick and dirty fix is to strip the database prefix from the list of tables. This

Happens in function get_list_of_tables (). Adding the following line right behind line 835

Will strip the prefixing schema:

Map {s/^ .*? \. // O} @ dbh_tables;

A long term fix wocould be to avoid $ dbh-> tables () (it is marked deprecated anyway) and use either table_info () or plain show tables instead.