mysql版本是5.1.49
# uname -a
linux lodb192168000046 2.6.18-238.19.1.el5 #1 smp fri jul 15 07:31:24 edt 2011 x86_64 x86_64 x86_64 gnu/linux
# cat /etc/issue
centos release 5.6 (final)
kernel \r on an \m
# mysqlhotcopy -u root -p '密码' 数据库名 备份目录
can't locate dbi.pm in @inc (@inc contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at bin/mysqlhotcopy line 8.
begin failed--compilation aborted at bin/mysqlhotcopy line 8.
上面出错是因为perl-dbd-mysql未安装:
# rpm -qa | grep perl-dbd
下载并安装perl-dbd-mysql提示缺少libmysqlclient.so.15:
# rpm -ivh perl-dbd-mysql-3.0007-2.el5.x86_64.rpm
error: failed dependencies:
libmysqlclient.so.15()(64bit) is needed by perl-dbd-mysql-3.0007-2.el5.x86_64
libmysqlclient.so.15(libmysqlclient_15)(64bit) is needed by perl-dbd-mysql-3.0007-2.el5.x86_64
perl(dbi) is needed by perl-dbd-mysql-3.0007-2.el5.x86_64
看看 libmysqlclient.so.15这个文件是否存在
# locate libmysqlclient.so.15
/usr/local/mysql/lib/mysql/libmysqlclient.so.15
/usr/local/mysql/lib/mysql/libmysqlclient.so.15.0.0
结果显示libmysqlclient.so.15文件是有的, 只是不在/usr/lib目录下而已:
我们只需要使用ldconfig 指定路径即可，下面安装mysql-shared-compat-5.0.95-1.glibc23.x86_64.rpm包则可跳过
#ldconfig /usr/local/mysql/lib/mysql
因为我的版本是5.1.49, 其实是有libmysqlclient的，但版本为locate libmysqlclient.so.16
# locate libmysqlclient.so.16
/usr/local/mysql-5.1.49-linux-x86_64-glibc23/lib/libmysqlclient.so.16
/usr/local/mysql-5.1.49-linux-x86_64-glibc23/lib/libmysqlclient.so.16.0.0
那我们使用mysql-shared-compat 的rpm包：
下载mysql-shared库文件, 下载地址：
先查包里面是否有libmysqlclient.so.15这个文件
# rpm -qilp mysql-shared-compat-5.0.95-1.glibc23.x86_64.rpm
...
/usr/lib64/libmysqlclient.so
/usr/lib64/libmysqlclient.so.12
/usr/lib64/libmysqlclient.so.12.0.0
/usr/lib64/libmysqlclient.so.14
/usr/lib64/libmysqlclient.so.14.0.0
/usr/lib64/libmysqlclient.so.15
/usr/lib64/libmysqlclient.so.15.0.0
/usr/lib64/libmysqlclient_r.so
/usr/lib64/libmysqlclient_r.so.12
/usr/lib64/libmysqlclient_r.so.12.0.0
/usr/lib64/libmysqlclient_r.so.14
/usr/lib64/libmysqlclient_r.so.14.0.0
/usr/lib64/libmysqlclient_r.so.15
/usr/lib64/libmysqlclient_r.so.15.0.0
/usr/lib64/libndbclient.so
/usr/lib64/libndbclient.so.2
/usr/lib64/libndbclient.so.2.0.0
从执行结果上看是有的，，安装此rpm包 可以彻底解决关于类似 libmysqlclient.so 的问题。
# rpm -ihv mysql-shared-compat-5.0.95-1.glibc23.x86_64.rpm
更新一下文件树库, 然后此时就会看到libmysqlclient.so.15在/usr/lib64目录下也有一份:
# updatedb
# locate libmysqlclient.so.15
/usr/lib64/libmysqlclient.so.15
/usr/lib64/libmysqlclient.so.15.0.0