Mysqlhotcopy配置

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;