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
On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey gto...@ffn.com 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
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 gto...@ffn.com wrote:
When using innodb, your data is stored in the data/ibdata* files. Copying
the database
@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
gto...@ffn.commailto:gto...@ffn.com wrote:
When using innodb, your data
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 gto...@ffn.com wrote:
When