From: Daevid Vincent
Date: September 2 2009 8:09pm
Subject: RE: Problem w/ mysqldump
List-Archive: http://lists.mysql.com/mysql/218571
Message-Id: <0A18DA2E7E5F4385B2E86E50BBC02CC0@mascorp.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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=daevid@stripped
>