mysqlhotcopy 运行错误
时间:2008-08-07 来源:r_a
运行如下:
[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. 源自:http://bugs.mysql.com/bug.php?id=27303
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. 源自:http://bugs.mysql.com/bug.php?id=27303
相关阅读 更多 +