Problem w/ mysqldump

Victor Subervi victorsubervi at
Wed Sep 2 14:43:22 CEST 2009

Obviously I'm sure. It created the file. But the file was blank. How can I
do a mysqldump in mysql itself?

On Wed, Sep 2, 2009 at 8:13 AM, Nitebirdz <nitebirdz at> wrote:

>  On Wed, Sep 02, 2009 at 06:43:12AM -0400, Victor Subervi wrote:
> > Hi:
> > I have the following python code:
> > import os
> > os.system("mysqldump -u root -pPASSWORD --opt spreadsheets > dump.sql")
> > 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?
> Are you sure the password you entered is correct?  I tested the code and
> it worked fine for me.  However, when I used an incorrect password, it
> returned an error and did create an empty file, just as you describe.
> --
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the Python-list mailing list