While not python, maybe this bash script will give you some clues?
http://daevid.com/content/examples/daily_backup.php
Also, please don't cross post to multiple lists. Not everyone on this mySQL
list is on the python list and vice versa. It's just bad netiquette.
> -----Original Message-----
> From: news [mailto:news@stripped] On Behalf Of Emile van Sebille
> Sent: Wednesday, September 02, 2009 7:18 AM
> To: mysql@stripped
> Cc: python-list@stripped
> Subject: Re: Problem w/ mysqldump
>
> On 9/2/2009 3:43 AM Victor Subervi said...
> > Hi:
> > I have the following python code:
> > import os
> > os.system("mysqldump -u root -pPASSWORD --opt spreadsheets
> > dump.sql")
>
> First, test this at the system command line -- you'll likely get an
> empty file there as well, so calling from within python
> simply does the
> same.
>
> Then read the mysqldump docs for the command arguments and supply the
> database name...
>
> Emile
>
>
> > This nicely creates the file...but the file is empty! The
> database exists
> > and has lots of data, I double-checked it. If there is
> nothing wrong with my
> > code, is there some way to do the same thing from within
> MySQL? Can I at
> > least print everything to screen and copy it? Where would I
> find my database
> > in Windoze?
> > TIA,
> > Victor
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
