mysqlhotcopy hint error cant locate DBI.PM solution

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.

Error reason: The system did not press the install DBI component.

DBI (Database Interface) is the interface for Perl to connect to databases. It is the best way to connect to a database in Perl, and he supports including

The vast majority of databases such as ORCAL,SYBASE,MYSQL,DB2

Solution:

The code is as follows	Copy Code
Apt-get Install Libclass-dbi-mysql-perl

This method is suitable for Debian,ubuntu,centos to try Yum

If it's Redhat/centos,

Execute command

The code is as follows	Copy Code
01.yum Install PERL-DBI perl-dbd-mysql-y

If it's a stool, Ubuntu,

Execute command
01.apt-get PERL-DBI Perl-dbd-mysql

Workaround Two

Install DBI

Check DBI

SQL code

The code is as follows	Copy Code
1.rpm-qa |grep PERL-DBD | grep MySQL Rpm-qa |grep PERL-DBD | grep MySQL

Installation

SQL code

The code is as follows	Copy Code
1.yum-y Install Perl-dbd-mysql Yum-y Install Perl-dbd-mysql

Or a separate dbi, data-showtable, dbd-mysql three components

Using Mysqlhotcopy

SQL code

code is as follows	copy code
1./usr/local/ webserver/mysql5.1.57/bin/mysqlhotcopy  tongchao/data1/backup/tongchao