How do i correct Mysqldump Error?

Hi I'm trying to make a dump of my database but keep getting errors, taken over the server from an unperforming contrctor but my knowlege of linux is basic, can you hlp?

ross@da1pf:~$ -su
-bash: -su: command not found
ross@da1pf:~$ su -
Password:
root@da1pf:~# mysqldump -u business4s_B4S -p business4s_B4S > b4s_13-10-2014.sql
mysqldump: /usr/local/mysql/lib/libmysqlclient.so.16: no version information ava                                                                                        ilable (required by mysqldump)
mysqldump: relocation error: mysqldump: symbol disabled_my_option, version libmy                                                                                        sqlclient_16 not defined in file libmysqlclient.so.16 with link time reference
root@da1pf:~# ^C
root@da1pf:~# ^C
root@da1pf:~# apt-get install -t unstable libmysqlclient16
Reading package lists... Done
Building dependency tree
Reading state information... Done
libmysqlclient16 is already the newest version.
libmysqlclient16 set to manually installed.
0 upgraded, 0 newly installed, 0 to remove and 71 not upgraded.
root@da1pf:~# mysqldump -u business4s_B4S -p business4s_B4S > b4s_13-10-2014.sql
mysqldump: /usr/local/mysql/lib/libmysqlclient.so.16: no version information available (required by mysqldump)
mysqldump: relocation error: mysqldump: symbol disabled_my_option, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference
root@da1pf:~# ^C
root@da1pf:~# cd /
root@da1pf:/# find . -name mysqldump
./usr/bin/mysqldump
./usr/local/mysql-5.5.9-linux2.6-x86_64/bin/mysqldump
root@da1pf:/# ^C
root@da1pf:/#


Any help would be greately appreciated.
LVL 1
MulithAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KimputerCommented:
can you check your mysql-libs status (installed?)
0
MulithAuthor Commented:
Still pretty new to Linux so not sure if doing this correct?

root@da1pf:/# dpkg -s mysql-libs
Package `mysql-libs' is not installed and no info is available.
Use dpkg --info (= dpkg-deb --info) to examine archive files,
and dpkg --contents (= dpkg-deb --contents) to list their contents.
root@da1pf:/# dpkg -s mysql55-libs
Package `mysql55-libs' is not installed and no info is available.
Use dpkg --info (= dpkg-deb --info) to examine archive files,
and dpkg --contents (= dpkg-deb --contents) to list their contents.
0
KimputerCommented:
libmysqlclient 1.6 is old by the way, there's already 1.8
Is your Debian old, or you kept it up to date (if up to date, use 1.8)
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

MulithAuthor Commented:
Debian 6.0.7 (squeeze)
0
KimputerCommented:
Too bad it's a bit old.

Try to reset it like this:

cd /usr/local/mysql/lib
rm -f libmysqlclient.so.16
apt-get update
apt-get install libmysqlclient16

Open in new window

0
MulithAuthor Commented:
root@da1pf:/# cd /usr/local/mysql/lib
root@da1pf:/usr/local/mysql/lib# rm -f libmysqlclient.so.16
root@da1pf:/usr/local/mysql/lib# apt-get update
Get:1 http://debian.mirrors.ovh.net squeeze Release.gpg [1,655 B]
Ign http://debian.mirrors.ovh.net/debian/ squeeze/main Translation-en
Ign http://debian.mirrors.ovh.net/debian/ squeeze/main Translation-en_GB
Get:2 http://debian.mirrors.ovh.net squeeze Release [96.0 kB]
Get:3 http://debian.mirrors.ovh.net squeeze/main Sources [4,537 kB]
Get:4 http://security.debian.org squeeze/updates Release.gpg [836 B]
Ign http://security.debian.org/ squeeze/updates/main Translation-en
Ign http://security.debian.org/ squeeze/updates/main Translation-en_GB
Get:5 http://security.debian.org squeeze/updates Release [86.9 kB]
Get:6 http://security.debian.org squeeze/updates/main Sources [139 kB]
Get:7 http://security.debian.org squeeze/updates/main amd64 Packages [367 kB]
Get:8 http://debian.mirrors.ovh.net squeeze/main amd64 Packages [6,527 kB]
Fetched 11.8 MB in 2s (4,580 kB/s)
Reading package lists... Done
root@da1pf:/usr/local/mysql/lib# apt-get install libmysqlclient16
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  libmysqlclient-dev mysql-common
The following packages will be upgraded:
  libmysqlclient-dev libmysqlclient16 mysql-common
3 upgraded, 0 newly installed, 0 to remove and 112 not upgraded.
Need to get 5,237 kB of archives.
After this operation, 32.8 kB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://debian.mirrors.ovh.net/debian/ squeeze/main mysql-common all 5.1.73-1 [71.2 kB]
Get:2 http://debian.mirrors.ovh.net/debian/ squeeze/main libmysqlclient-dev amd64 5.1.73-1 [3,194 kB]
Get:3 http://debian.mirrors.ovh.net/debian/ squeeze/main libmysqlclient16 amd64 5.1.73-1 [1,971 kB]
Fetched 5,237 kB in 0s (13.8 MB/s)
Reading changelogs... Done
(Reading database ... 41289 files and directories currently installed.)
Preparing to replace mysql-common 5.1.66-0+squeeze1 (using .../mysql-common_5.1.73-1_all.deb) ...
Unpacking replacement mysql-common ...
Preparing to replace libmysqlclient-dev 5.1.66-0+squeeze1 (using .../libmysqlclient-dev_5.1.73-1_amd64.deb) ...
Unpacking replacement libmysqlclient-dev ...
Preparing to replace libmysqlclient16 5.1.66-0+squeeze1 (using .../libmysqlclient16_5.1.73-1_amd64.deb) ...
Unpacking replacement libmysqlclient16 ...
Processing triggers for man-db ...
Setting up mysql-common (5.1.73-1) ...
Setting up libmysqlclient16 (5.1.73-1) ...
Setting up libmysqlclient-dev (5.1.73-1) ...
root@da1pf:/usr/local/mysql/lib# cd /
root@da1pf:/# mysqldump -u business4s_B4S -p business4s_B4S > b4s_13-10-2014.sql
mysqldump: /usr/local/mysql/lib/libmysqlclient.so.16: no version information available (required by mysqldump)
mysqldump: relocation error: mysqldump: symbol disabled_my_option, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference


no luck.
0
KimputerCommented:
I just noticed you have two binaries,
can you check the version of each?

./usr/bin/mysqldump
 ./usr/local/mysql-5.5.9-linux2.6-x86_64/bin/mysqldump

Or just run the full path/command with both.
If not too much trouble remove mysql client 5.5 and revert back to 5.1
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.