Originally Posted by prak86
I got the rpm files for this. Should i make any configuration change while installing this rpm file?
Just installing it should be ok....
But read below also as there are options.
Your old mysql installation has the libmysqlclient.so module installed in the lib directory.
Your new installation does too but it is in a different location.
The perl DBD::mysql installation when installed from source or cpan looks for this module at /usr/local/mysql/lib/libmysqlclient.so.
YOu didnt really say how you installed the newest version of mysql, but at a guess i would say if you searched for the libmysqlclient.so within that installation, it would be in a different location. Maybe something like /usr/local/mysql-5.1.39-linux-x86_64-glibc23/lib/libmysqlclient.so.
So there are a number of solutions to this. One is to symlink the new installation directory to a name like mysql.
Firstly, check the location of the old installation if it still exists.
Secondly , change into the directory of the new installation.
[root@xxxx ~]# ls -la | grep mysql*
drwxr-xr-x 2 root root 4096 Jan 21 09:07 mysql-1234
ln -s mysql-1234 mysql
and then check
root@xxxx testmysql]# ls -la
drwxr-xr-x 3 root root 4096 Jan 21 09:09 .
drwxr-x--- 41 root root 4096 Jan 21 09:08 ..
lrwxrwxrwx 1 root root 10 Jan 21 09:09 mysql -> mysql-1234
drwxr-xr-x 2 root root 4096 Jan 21 09:09 mysql-1234
then just make sure you can cd mysql/lib/ and in here you should see the libmysqlclient.so.
if you cant, then create a symlink so that it links to whereever it is.
Find mysqlclient.so using locate if need be.