Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 03:02 pm EDT

Geeklog Forums

mysqldump


santosh

Anonymous
blank
hi dirk,
what does this mean?

while taking back up....There was an error.
incorrect path or mysqldump utility not executable.
Check $_DB_mysqldump_path definition in config.php.
Variable currently defined as: /usr/bin/mysqldump


how do i rectify this error?

thanx
 Quote

santosh

Anonymous
I am working on a linux server
 Quote

Status: offline

destr0yr

Forum User
Full Member
Registered: 07/06/02
Posts: 324
Quote by santosh: hi dirk,
what does this mean?

while taking back up....There was an error.
incorrect path or mysqldump utility not executable.
Check $_DB_mysqldump_path definition in config.php.
Variable currently defined as: /usr/bin/mysqldump


how do i rectify this error?

thanx

I wonder if Dirk ever gets tired of people requesting his direct support. God knows I would.

Anyways, the issue is exactly what the error says, your path to mysqldump is incorrect or the utility is not an executable. If you have SSH access to the server, login and try running "which mysqldump", without quotes. It should give you the proper location to that file. Alternatively, if you have root access and the "which" command doesn't work, try running "updatedb" followed by "locate mysqldump". Correct the path with the returned value in your config.php.

If it still doesn't work, you may want to check that you have access to run the command as the c urrent user (the permissions of the file should be 755 AFAIK).

If the file is not located located anywhere, make sure you have the proper MySQL packages installed. I believe on an RPM based system (fedora, redhat, centos, etc.) the package is MySQL-client.
-- destr0yr
"I love deadlines. I like the whooshing sound they make as they fly by." -- Douglas Adams
 Quote

sigh

Anonymous
what does any of that mean?

 Quote

Thin

Anonymous
basically it means that something isn't setup quite as expected with your webhosting environment. If you have no idea what the previous answer is talking about - then you need to forward your problem and / or this thread to your web hosting company or IT support dept
 Quote

getting better at this

Anonymous
confused
Could someone tell me where mysqldump is supposed to be located by default? I don't have SSH access and i don't really have anywhere i can put commands in such as "which mysqldump"

I'm getting the error stated above and I just want to find the correct path to the file.

Thanks
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by: getting better at this

Could someone tell me where mysqldump is supposed to be located by default?


/usr/bin/mysqldump is pretty popular (which is why it's the default), but it's also often in /usr/local/mysql/bin/mysqldump

If neither works, ask your hosting service ...

bye, Dirk
 Quote

getting better at this

Anonymous
confused
The only way I can contact my hosting service is by putting a trouble ticket in. I put one in about 5 months ago and they still haven't responded. Yeah, my hosting service sucks.

PLEASE oh please do you have any other path suggestions?

 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
The two I mentioned are the most popular, but in theory, it could be anywhere. That really depends on the server setup and is something only your hosting service would know ...

bye, Dirk
 Quote

All times are EDT. The time is now 03:02 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content