PHP mysqldump doesn't work

Question

I've the code shown below but nothing happens after execution

system('mysqldump -u USER -pPASS DB > /tmp/bckp.sql');

What is wrong with this code?

Sultan

if you run that command from the command line, does it work? — Derek Organ
– Derek Organ, Commented Oct 11, 2010 at 12:14

Mark · Accepted Answer · 2010-10-11 17:02:55Z

2

You most likely need to specify the full path to mysqldump as it probably isn't in your PATH environment variable for the user PHP is running as. Go to command line on the server and run

which mysqldump

It will spit out the full path. Then replace mysqldump in your system() command with that full path

answered Oct 11, 2010 at 17:02

Mark

6,2261 gold badge34 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

devasia2112 Over a year ago

which is a command not recognized on windows systems. There another one to know the absolute path?

oezi · Accepted Answer · 2010-10-11 12:17:19Z

1

there could be thausands of things going wrong:

do you get any error messages?
have you tried to echo system(... - and whats the result?
what is the return value?
have you tried to use exec or passthru instead?
are you sure your db-name, user and password are spelled correctly?
what happens if you fire that command on the terminal on your own?

some more information would be realy useful to help you.

answered Oct 11, 2010 at 12:17

oezi

51.9k10 gold badges102 silver badges119 bronze badges

2 Comments

sultan Over a year ago

If execute this command directly from my console it works well, but via php script it doesn't

sultan Over a year ago

Seems there were restrictions on executing of a system commands, so for now it works

Collectives™ on Stack Overflow

PHP mysqldump doesn't work

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related