Solved

How do i correct Mysqldump Error?

Posted on 2014-10-13
7
403 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 36

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 36

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
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 
LVL 1

Author Comment

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

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 36

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

Stressed Out?

Watch some penguins on the livecam!

Question has a verified solution.

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

The purpose of this article is to show how we can create Linux Mint virtual machine using Oracle Virtual Box. To install Linux Mint we have to download the ISO file from its website i.e. http://www.linuxmint.com. Once you open the link you will see …
If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

687 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