missing mysqldump

[nobaloney]

Running latest version of CentOS 3 (yes, that's an oxymoron), and can no longer backup mysql; backup system returns error:

Unable to find /usr/bin/mysqldump to create mysql backup

Does anyone have a copy which will work on this version:

[root@da11 root]# mysqld --version
mysqld  Ver 4.0.17-standard for pc-linux on i686 (Official MySQL RPM)
[root@da11 root]#

???

I need to update the box soon but I need to give the 20 users on it some advance notice and I'd love to be able to make a backup first.

Anyone know if the backups will be restorable on php5?

Thanks.

Jeff

 

[zEitEr]

Do you mean MySQL 5, or PHP 5? I've recently done the same: moved accounts from CentOS 3 (PHP4, MySQL4) into CentOS 5 (PHP5.2, MySQL 5.1), none issue has come with importing MySQL DBs.

Did you try to get mysqldump from a RPM, taken from here http://files.directadmin.com/services/es_3.0/ ?

If you want I can send you one:

# /usr/bin/mysqldump -V
/usr/bin/mysqldump Ver 9.10 Distrib 4.0.17, for pc-linux (i686)

coming together with

# mysqld --version
mysqld Ver 4.0.17-standard for pc-linux on i686 (Official MySQL RPM)

 

[nobaloney]

Do you mean MySQL 5, or PHP 5?

My error. MySQL5.

I've recently done the same: moved accounts from CentOS 3 (PHP4, MySQL4) into CentOS 5 (PHP5.2, MySQL 5.1), none issue has come with importing MySQL DBs.

But I need to export them first .

Did you try to get mysqldump from a RPM, taken from here http://files.directadmin.com/services/es_3.0/ ?

No; I didn't; I probably should.

If you want I can send you one:

Please do if it's convenient; I probably won't get the time to try until some time Sunday. If you can send it in a tarball attached to an email that would be most convenient; I run linux on the desktop.

Thanks.

Jeff

 

[zEitEr]

I've send you a copy by email, and according to exim logs, it was delivered to your server:

2011-08-20 14:09:55 1QufgV-0004G4-5w => [email protected] F=<support@vds****.net> R=lookuphost T=remote_smtp S=903911 H=mx.nobaloney.net [74.124.205.95] X=TLSv1:AES256-SHA:256 C="250 OK id=1Qufgf-00076r-F7"
2011-08-20 14:09:56 1QufgV-0004G4-5w Completed

 

[SeLLeRoNe]

Doesn't mysqldump come out with mysql?

whereis mysqldump

maybe should help, sometimes it happend to me too to dont find the mysqldump file that was stored elsewhere

Regards

 

[sde]

I know it's not what you're asking, and it sounds like a temporary need anyway, so just in case you haven't thought of it yet (i find that doubtful ), just use another system with the -h param.

(from some other system)

$ mysqldump -u [username] -p[password] -h [centos3host] --all-databases > centos3box-all-databases.sql

 

[nobaloney]

The file sent to me by user zEitEr worked perfectly; thanks! I've been late in getting back to the forums, but the server is working fine now.

@SeLLeRoNe:

Nope; I tried that. Somehow it had gotten deleted from the server within the previous week.

@sde:

Yes it's a temporary need, but that means at least a month because of notification issues to clients before moving them, so in the meantime it's nice to have automated backups working again.

Thanks, everyone!

Jeff

 

[zEitEr]

@Jeff,

It was a pleasure to help you.

 

[Sewdn]

It seems my clean directadmin install on ubuntu 10.04 is also missing mysqldump.
How to install mysqldump without (re)installing mysql-client and compromising the directadmin setup?

Thanks!

 

[zEitEr]

# updatedb
# locate mysqldump

???

 

[Sewdn]

seems i was a bit too quick, posting on this forum.

Locate pointed me to all kinds of mysqldump executables. I added symbolic link in /usr/local/bin.

thanks!

 

[Dennis]

Hi,

I have done an upgrade from Mysql 5.1 to Mysql 5.6 and it seems to have lost the mysqldump. Is there a way to only install or download the mysqldump program?

Tried to search with locate and it is really gone....only got mysqldumpslow for some reason.

Tnx!

EDIT: Got it working, was a corrupt download of the MySQL-client RPM. Downloaded again and extracted the mysqldump.