I checked my own backup script from earlier years and everything was good. You know, if I could simply figure out where the data was actually stored, in what file, I could copy it over to another computer. Any ideas? Thanks, V
On Wed, Sep 2, 2009 at 4:09 PM, Daevid Vincent <dae...@daevid.com> wrote: > 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:n...@ger.gmane.org] On Behalf Of Emile van Sebille > > Sent: Wednesday, September 02, 2009 7:18 AM > > To: mysql@lists.mysql.com > > Cc: python-l...@python.org > > 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=dae...@daevid.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=victorsube...@gmail.com > >
