mysqldump from within python script but command not found

Question

I need to execute mysqldump from within a django function. I can do so easily enough from the terminal command line, but when I try to run it from within the python script, I get an error:

sh: mysqldump: command not found

when running the following.

filestamp = date.today()
dumpcmd = "mysqldump -u root appdb > appdb%s.out" % (filestamp)
os.system(dumpcmd)

I think the problem has something to do with the Path in either the django application or Eclipse, but I can't figure out why mysqldump can't be found from within the django app but it can be from the command line / virtualenv

I want to automate the syncing of a database on my local machine with the same database hosted online. The first step I usually pursue is mysqldump, so I'm trying to replicate that programatically. — Ed.
– Ed., Commented Dec 14, 2016 at 17:34
almost a duplicate: stackoverflow.com/questions/38916163/… — e4c5
– e4c5, Commented Dec 17, 2016 at 14:08

Community · Accepted Answer · 2017-05-23 10:30:40Z

0

make sure mysqldump is in your path

$ whereis mysqldump; echo $PATH
mysqldump: /usr/bin/mysqldump /usr/share/man/man1/mysqldump.1.gz
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

and/or

using mysqldump and mysql inside python

import subprocess
subprocess.Popen('mysqldump -h localhost -P 3306 -u -root appdb > appdb.sql', shell=True)

Or use the full path in the Python statement. e.g. /usr/bin/mysqldump

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Dec 11, 2016 at 21:16

larvarunt

164 bronze badges

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

Collectives™ on Stack Overflow

mysqldump from within python script but command not found

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related