?
Solved

How do i correct Mysqldump Error?

Posted on 2014-10-13
7
Medium Priority
?
419 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
WordPress Tutorial 3: Plugins, Themes, and Widgets

The three most common changes you will make to your website involve the look (themes), the functionality (plugins), and modular elements (widgets).

In this article we will briefly define each again, and give you directions on how to install them.

 
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 2000 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
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…
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.
Suggested Courses
Course of the Month11 days, 6 hours left to enroll

770 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