Can't locate DBI.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.1

/usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10

/usr/local/lib/site_perl .) at /usr/local/webserver/mysql/bin/mysqlhotcopy line 8.

BEGIN failed--compilation aborted at /usr/local/mysql/bin/mysqlhotcopy line 8.

錯誤原因:系統沒有按安裝DBI組件.

DBI(Database Interface)是perl連接數據庫的接口,其是perl連接數據庫的最優秀方法,他支持包括 Orcal,Sybase,mysql,db2等絕大多數的數據庫

解決辦法:apt-get install libclass-dbi-mysql-perl

此方法適用于debian,ubuntu，centos可以改用yum試試,如果是Redhat/CentOS,執行命令,代碼如下:

01.yum install perl-DBI perl-DBD-MySQL -y 

如果是大便、Ubuntu，執行命令

01.apt-get perl-DBI perl-DBD-MySQL

解決方法二

安裝 dbi,檢查dbi,Sql代碼如下:

1.rpm -qa |grep perl-DBD | grep MySQL rpm -qa |grep perl-DBD | grep MySQL  

安裝,Sql代碼如下:

yum -y install perl-DBD-MySQL  

yum -y install perl-DBD-MySQL  

或者單獨裝DBI、Data-ShowTable、DBD-mysql 三個組件.

使用mysqlhotcopy,Sql代碼如下:

/usr/local/webserver/mysql5.1.57/bin/mysqlhotcopy  tongchao /data1/backup/tongchao