Mysqlhotcopy配置

superzgc

1:安装DBI-1.609
#perl Makefile.PL
#make
#make test
#make install
2:安装perl-DBI-1.32-5-i386.rpm
3:安装mysql-client-standard.rpm
4:安装mysql-devel-standard.rpm
5:安装DBD-mysql
#perl Makefile.PL
#make
#make test
#make install
6:运行mysqlhotcopy
#mysqlhotcopy –u root –p “123456” dbname /app/tmp
7:如果出错
Invalid db.table name ‘yemaosheng_com’.'blog’ at /usr/local/bin/mysqlhotcopy line 855.
解决方法:
vi /usr/bin/mysqlhotcopy
#在第 835 下新增一行
835 my @dbh_tables = eval { $dbh->tables() };
836 map { s/^.*?\..//o } @dbh_tables;


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u3/110700/showart_2156252.html