Shulou(Shulou.com)05/31 Report--

Mysqlhotcopy backup error report how to solve, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Problem: mysqlhotcopy backup error

/ 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.

Solve

Download:

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

Finally, after the compilation and installation, it is found that the error is still reported:

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

This is because there is a problem with the path configuration after tar installs mysql

Vi / etc/ld.so.conf

Add the library file path of mysql

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

Ldconfig

When the mysqlhotcopy is executed again, everything is fine.

One service has the following problems:

Check the information on the treatment of the following questions, and write down another question first:

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.

Reason: the system does not install DBI components by press.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.