Problem w/ mysqldump

Emile van Sebille emile at
Wed Sep 2 16:18:28 CEST 2009

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

More information about the Python-list mailing list