mysqlhotcopy备份报错该怎么解决

mysqlhotcopy备份报错该怎么解决，很多新手对此不是很清楚，为了帮助大家解决这个难题，下面小编将为大家详细讲解，有这方面需求的人可以来学习下，希望你能有所收获。

问题：mysqlhotcopy备份报错

/usr/local/mysql/bin/mysqlhotcopy -u root -p  --addtodest --noindices --flushlog -q qeedoo /tmp/bak

install_driver(mysql) failed: Cant 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 hasnt been fully installed,

or perhaps the capitalisation of mysql isnt right.

Available drivers: DBM, ExampleP, File, Proxy, Sponge.

解决

-：

tar zxvf DBD--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: Cant 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 isnt 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的时候，一切正常。

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

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

Cant 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组件。

看完上述内容是否对您有帮助呢？如果还想对相关知识有进一步的了解或阅读更多相关文章，请关注亿速云行业资讯频道，感谢您对的支持。