[root@DBMS bin]# /usr/local/mysql/bin/mysqlhotcopy -u root -p 'PASSWORD' wubolu /home
Can't locate DBI.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /usr/local/mysql/bin/mysqlhotcopy line 8. |
分析: mysqlhotcopy 只是针对MyISAM ,ISAM表类型,mysqlhotcopy去找到第8行,缺少DBI,DBI(Database Interface)是perl连接数据库的接口,其是perl连接数据库的最优秀方法,他支持包括Orcal,Sybase,mysql,db2等绝大多数的数据库。把perl-DBD-MySQL装上:
yum install perl-DBD-MySQL
再次运行:
[root@DBMS bin]# /usr/local/mysql/bin/mysqlhotcopy -u root -p 'PASSWORD' wubolu /home
DBI connect(';host=localhost;mysql_read_default_group=mysqlhotcopy','root',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at ./mysqlhotcopy line 180 |
还是有问题,在mysqlhotcopy内也找不到重新指定mysql.sock位置内容,一般地mysql.sock随mysql启动后都会在/tmp下,看来只能创建个链接过去了:
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
OK,问题解决。