Solved

How do i correct Mysqldump Error?

Posted on 2014-10-13
7
380 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
  • 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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The purpose of this article is to demonstrate how we can upgrade Python from version 2.7.6 to Python 2.7.10 on the Linux Mint operating system. I am using an Oracle Virtual Box where I have installed Linux Mint operating system version 17.2. Once yo…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

762 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now