mysqlhotcopy 缺少DBI不能使用问题解决

[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.
BEGIN failed--compilation aborted 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，问题解决。

评论

1 楼 sunfeizhi 2015-09-13  

感谢博主