While not python, maybe this bash script will give you some clues?
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
> Then read the mysqldump docs for the command arguments and supply the
> database name...
> > 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: