mysqlhotcopy 运行错误解决一例

mysqlhotcopy 运行错误解决一例

mysqlhotcopy运行如下：

[root@local_slavedb ~]# mysqlhotcopy test /tmp

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

解决方法：

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 would be to avoid $dbh->tables() (it is marked deprecated anyway) and use either table_info() or plain SHOW TABLES instead.