红联Linux门户
Linux帮助

mysqlhotcopy 运行错误

发布时间:2008-08-10 00:03:59来源:红联作者:Ailone
运行如下:

[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.
文章评论

共有 0 条评论