mysqlhotcopy 运行错误解决一例

2014-11-24 17:33:15 · 作者: · 浏览: 0

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.