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=arch...@jab.org
