Mysqldump with python

Question

I am trying to save a mysql database dump in a python script. Here is what I have:

filepath = os.path.join(BACKUPS_FOLDER, '%s.sql' % date)
print filepath # /Users/david/Desktop/updates/_backups/2013-04-07.sql
subprocess.call(shlex.split('mysqldump -u root updates > %s' % filepath ))

I get the following error:

mysqldump: Couldn't find table: ">"

What I am doing incorrectly here?

I think you don't have the shell when calling mysqldump so it will pass > as a parameter (in this case as a table name) — agim
– agim, Commented Apr 7, 2013 at 22:57

agim · Accepted Answer · 2013-04-07 22:56:04Z

5

You can call mysqldump with the option --result-file=file (subprocess.call(shlex.split('mysqldump -u root updates --result-file=%s' % filepath )))since it will interpret the > as a table name.

answered Apr 7, 2013 at 22:56

agim

1,84113 silver badges19 bronze badges

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

2 Comments

Tom Miller Over a year ago

Exactly what I was looking for!

getglad Over a year ago

Would be good to note that Python 3.5 and higher, subprocess.run is the preferred API - docs.python.org/3.7/library/subprocess.html#subprocess.run

David542 · Accepted Answer · 2013-04-07 22:58:34Z

0

This is what I did, using communicate() to get the output and then write to a file:

date = str(datetime.datetime.now().date())
filepath = os.path.join(BACKUPS_FOLDER, '%s.sql' % date)

args = shlex.split("mysqldump -u root updates")
p1 = subprocess.Popen(args, stdout=subprocess.PIPE, stderr=subprocess.STDOUT)
dump_output = p1.communicate()[0]

f = open(filepath, "wb")
f.write(dump_output)
f.close()

answered Apr 7, 2013 at 22:58

David542

112k211 gold badges581 silver badges1.1k bronze badges

Collectives™ on Stack Overflow

Mysqldump with python

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related