Problem w/ mysqldump

Victor Subervi victorsubervi at gmail.com
Wed Sep 2 08:43:22 EDT 2009


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

On Wed, Sep 2, 2009 at 8:13 AM, Nitebirdz <nitebirdz at sacredchaos.com> 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.
>
> --
> http://mail.python.org/mailman/listinfo/python-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20090902/2e8e384c/attachment.html>


More information about the Python-list mailing list