Re: Problem w/ mysqldump

2009-09-04 Thread Victor Subervi
I got essentially the same printout. There were the following, among many others: mysqldump.exe mysqldump.pdb What's a *.pdb file? Don't know it matters. If there were just some darn way to know where that daggone database is, I could copy it and move it to another machine. TIA, V On Thu, Sep 3, 2

Re: Problem w/ mysqldump

2009-09-03 Thread Nitebirdz
On Wed, Sep 02, 2009 at 04:45:02PM -0400, Victor Subervi wrote: > > I tried running it like you said, got this error: > 'mysqldump' is not a recognized internal or external command. > If I could just figure out in what file the data were stored, I could copy > it and try it in another computer. Any

Re: Problem w/ mysqldump

2009-09-02 Thread Victor Subervi
I tried running it like you said, got this error: 'mysqldump' is not a recognized internal or external command. If I could just figure out in what file the data were stored, I could copy it and try it in another computer. Any ideas? TIA, V On Wed, Sep 2, 2009 at 2:10 PM, Rami Chowdhury wrote: >

Re: Problem w/ mysqldump

2009-09-02 Thread Rami Chowdhury
I tried running the mysqldump command from the python prompt I think you were being asked to try running it from the command prompt (cmd.exe) -- it won't work from the Python prompt, of course. On Wed, 02 Sep 2009 10:50:55 -0700, Victor Subervi wrote: I am running this on Windoze. I do

Re: Problem w/ mysqldump

2009-09-02 Thread Victor Subervi
I am running this on Windoze. I do not use the mysql db without python. I'm just building something for a client. I tried running the mysqldump command from the python prompt. Didn't know I could do that :) It tells me "mysqldump is not defined" :( V On Wed, Sep 2, 2009 at 11:48 AM, Nitebirdz wrot

Re: Problem w/ mysqldump

2009-09-02 Thread Victor Subervi
Not sure how to test it at the command line as you recommend; however, I most certainly did supply the db name. I most certainly did check the docs. I also looked at code I had previously written that worked. So I'm stumped! Is there any way to print it out to screen or (better yet) print to screen

Re: Problem w/ mysqldump

2009-09-02 Thread Nitebirdz
On Wed, Sep 02, 2009 at 08:43:22AM -0400, Victor Subervi wrote: > > Obviously I'm sure. It created the file. But the file was blank. How can I > do a mysqldump in mysql itself? > As I said, I only got a blank file when the actual command itself failed. How do you dump the MySQL database itself w

Re: Problem w/ mysqldump

2009-09-02 Thread Emile van Sebille
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

Re: Problem w/ mysqldump

2009-09-02 Thread Victor Subervi
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 wrote: > On Wed, Sep 02, 2009 at 06:43:12AM -0400, Victor Subervi wrote: > > Hi: > > I have the following python code: > > import os > > os.syst

Re: Problem w/ mysqldump

2009-09-02 Thread Nitebirdz
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 doubl

Problem w/ mysqldump

2009-09-02 Thread Victor Subervi
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 d