Not in Windoze. The only folders I have inside the Programs/MySQL are Docs, bin and Shared V
On Wed, Sep 2, 2009 at 5:29 PM, Daevid Vincent <dae...@daevid.com> wrote: > If it's MYISAM tables, then they're all self contained in folders in > /var/lib/mysql/spreadsheets. Remember that if you do copy the files, to > shut > down mysql first or you could copy corrupt files. > > If you're using INNODB, then the schema is in that folder, but the actual > data is in the /var/lib/mysql/ib* files. Along with all the other INNODB > databases you may have on the system -- all mashed together. Hence the need > for a mysql dump tool ;-) > > Mysql dump is the better way to go in either situation. > > > -----Original Message----- > > From: Victor Subervi [mailto:victorsube...@gmail.com] > > Sent: Wednesday, September 02, 2009 1:43 PM > > To: Daevid Vincent; mysql@lists.mysql.com > > Subject: Re: Problem w/ mysqldump > > > > 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 > > > > > > > > > >
