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:
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
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 wrote:
> When using innodb, your data is stored in the data/ibdata* files. Copying
> the database directory is
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
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 innodb you need to 1. Shutdown the server 2. Copy
*everything* in
