问题：mysqlhotcopy备份报错 

/usr/local/mysql/bin/mysqlhotcopy -u root -p  --addtodest --noindices --flushlog -q qeedoo /tmp/bak install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .) at (eval 7) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available drivers: DBM, ExampleP, File, Proxy, Sponge.

解决

下载：

tar zxvf DBD-mysql-3.0008.tar.gz

cd /tmp/DBD-mysql-3.0008 perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config make  make install

 

最后编译安装完之后 发现还是报错：

install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.16: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.  at (eval 7) line 3 Compilation failed in require at (eval 7) line 3. Perhaps a required shared library or dll isn't installed where expected  at /usr/bin/mysqlhotcopy line 177

 

是因为tar安装mysql后的路径配置的有问题

vi /etc/ld.so.conf 

把mysql的这个库文件路径添加进去 

 

echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf

ldconfig

再执行mysqlhotcopy的时候，一切正常。  

 

有一台服务出现如下问题：

以下问题待遇查看资料，先记下另外这个问题：

Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-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.

原因：系统没有按安装DBI组件。

本文转自 holy2009 51CTO博客，原文链接:http://blog.51cto.com/holy2010/675403