Solved

How do i correct Mysqldump Error?

Posted on 2014-10-13
7
397 Views
Last Modified: 2014-11-27
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.
0
Comment
Question by:Mulith
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 35

Expert Comment

by:Kimputer
ID: 40376721
can you check your mysql-libs status (installed?)
0
 
LVL 1

Author Comment

by:Mulith
ID: 40376741
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
 
LVL 35

Expert Comment

by:Kimputer
ID: 40376828
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:Mulith
ID: 40376847
Debian 6.0.7 (squeeze)
0
 
LVL 35

Expert Comment

by:Kimputer
ID: 40376860
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
 
LVL 1

Author Comment

by:Mulith
ID: 40376873
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
 
LVL 35

Accepted Solution

by:
Kimputer earned 500 total points
ID: 40376888
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

Featured Post

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If your site has a few sections that need to be secure when data is transmitted between the server and local computer, such as a /order/ section for ordering or /customer/ which contains customer data, etc it would of course be recommended to secure…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question