mysqlhotcopy備份報(bào)錯(cuò)該怎么解決

139次閱讀

共計(jì) 1973 個(gè)字符，預(yù)計(jì)需要花費(fèi) 5 分鐘才能閱讀完成。

mysqlhotcopy 備份報(bào)錯(cuò)該怎么解決，很多新手對(duì)此不是很清楚，為了幫助大家解決這個(gè)難題，下面丸趣 TV 小編將為大家詳細(xì)講解，有這方面需求的人可以來(lái)學(xué)習(xí)下，希望你能有所收獲。

問(wèn)題：mysqlhotcopy 備份報(bào)錯(cuò)
/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–3.0008.tar.gz
cd /tmp/DBD-mysql-3.0008
perl Makefile.PL –mysql_config=/usr/local/mysql/bin/mysql_config
make
make install

最后編譯安裝完之后發(fā)現(xiàn)還是報(bào)錯(cuò)：
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

是因?yàn)?tar 安裝 mysql 后的路徑配置的有問(wèn)題
vi /etc/ld.so.conf
把 mysql 的這個(gè)庫(kù)文件路徑添加進(jìn)去

echo /usr/local/mysql/lib/mysql /etc/ld.so.conf
ldconfig

再執(zhí)行 mysqlhotcopy 的時(shí)候，一切正常。

有一臺(tái)服務(wù)出現(xiàn)如下問(wèn)題：
以下問(wèn)題待遇查看資料，先記下另外這個(gè)問(wèn)題：
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.
原因：系統(tǒng)沒(méi)有按安裝 DBI 組件。

看完上述內(nèi)容是否對(duì)您有幫助呢？如果還想對(duì)相關(guān)知識(shí)有進(jìn)一步的了解或閱讀更多相關(guān)文章，請(qǐng)關(guān)注丸趣 TV 行業(yè)資訊頻道，感謝您對(duì)丸趣 TV 的支持。

正文完