RE: DB/table problem

2009-09-10 Thread Gavin Towey
nes. Regards, Gavin Towey -Original Message- From: tly...@sitehelp.org [mailto:tly...@sitehelp.org] On Behalf Of Todd Lyons Sent: Thursday, September 10, 2009 3:44 PM To: Gavin Towey Cc: mysql@lists.mysql.com Subject: Re: DB/table problem On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey wrote:

RE: DB/table problem

2009-09-10 Thread Gavin Towey
mysql@lists.mysql.com Subject: Re: DB/table problem OK, All I have then is a bunch of .frm files. Can I recover the data from the FRM files if I install mysql 5.0 without INNODB? Thanks, On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey mailto:gto...@ffn.com>> wrote: When using innodb, your data i

Re: DB/table problem

2009-09-10 Thread Néstor
ell. 4. Restart mysql > > Regards, > Gavin Towey > > -Original Message- > From: Néstor [mailto:rot...@gmail.com] > Sent: Thursday, September 10, 2009 11:28 AM > To: mysql@lists.mysql.com > Subject: DB/table problem > > I am running mysql 5.0 on a windows 20

Re: DB/table problem

2009-09-10 Thread Todd Lyons
On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey wrote: > When using innodb, your data is stored in the data/ibdata* files.  Copying > the database directory is not a valid backup. > > In the future, I would suggest using mysqldump.  However if you want to make > a file-system copy backup with innod

RE: DB/table problem

2009-09-10 Thread Gavin Towey
the data directory 3. Store a copy of your my.ini with the backup as well. 4. Restart mysql Regards, Gavin Towey -Original Message- From: Néstor [mailto:rot...@gmail.com] Sent: Thursday, September 10, 2009 11:28 AM To: mysql@lists.mysql.com Subject: DB/table problem I am running mysql

DB/table problem

2009-09-10 Thread Néstor
I am running mysql 5.0 on a windows 2003 host with php and apache I am trying to restore a database from 08/28/2009. The backup is done by windows and all I do is copy the "data/scroller612" folder to the DATA folder in the MYSQL directory. when I restore/copy it I get the following errors my .e