MySQL database back up using Python

Question

I'm trying to write a python script which backs up the database every midnight. The code i am using is below:

from subprocess import call

call (["mysqldump", "-u", "root", "-p*****", "normalisation", ">", "date_here.sql"])

The first problem i came across is that mysql thinks the ">" is a table when it is not, the query works fine when i run it from the command line (see below)

$ mysqldump -u root -p***** normalisation > date_here.sql
$ ls
backup.py date_here.sql
$

Sencondly, how do i get the script to automatically run everymidnight?
Thirdly, i need the .sql file to be saved as the date of the back up.

Igor Serebryany · Accepted Answer · 2010-06-21 21:06:40Z

1

use a shell script. there's a million that do this task already online. you can generate the filename using the date command with the right format string, and you can make it run at a scheduled time using cron.

answered Jun 21, 2010 at 21:06

Igor Serebryany

3,3413 gold badges32 silver badges43 bronze badges

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

1 Comment

Craig Trader Over a year ago

By that argument, there would be no need for Perl, Python, Ruby, or any other scripting language.

Craig Trader · Accepted Answer · 2010-06-21 21:50:35Z

1

Your command is failing because output redirection is a function of the shell, not mysqldump. Try using Popen instead of call, as follows:

from subprocess import Popen

f = open( "date_here.sql", "w" )
x = Popen( ["mysqldump", "-u", "root", "-p*****", "normalisation"], stdout = f )
x.wait()
f.close()

This will allow you to handle redirecting to stdout within your program.

answered Jun 21, 2010 at 21:50

Craig Trader

15.7k6 gold badges41 silver badges56 bronze badges

Collectives™ on Stack Overflow

MySQL database back up using Python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related