List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:September 11 2009 1:27am
Subject:RE: DB/table problem
View as plain text  
No, the .frm files don't contain data.  They are only the table structure.  You should
always test your backup and restore procedure nefore you need to use it.

Regards,
Gavin Towey

From: Néstor [mailto:rotsen@stripped]
Sent: Thursday, September 10, 2009 4:35 PM
To: Gavin Towey
Cc: mysql@stripped
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
<gtowey@stripped<mailto:gtowey@stripped>> 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 innodb you need to 1. Shutdown the server 2. Copy *everything* in 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:rotsen@stripped<mailto:rotsen@stripped>]
Sent: Thursday, September 10, 2009 11:28 AM
To: mysql@stripped<mailto:mysql@stripped>
Subject: DB/table problem

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 .err file found on the
data directory:
==========================================================
090910 11:04:03090910 11:04:03 [ERROR] Cannot find table scroller612/cache
from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
how you can resolve the problem.
=========================================================

When I go to the above link it saids to run the "check table" statement,
but when I do this, I get below response:
=======================================================
mysql> check table scroller612.access;
+--------------------+-------+
----------+------------------------------------------+
| Table              | Op    | Msg_type | Msg_text
     |
+--------------------+-------+----------+------------------------------------------+
| scroller612.access | check | Error    | Table 'scroller612.access' doesn't
exist |
| scroller612.access | check | error    | Corrupt
      |
+--------------------+-------+----------+------------------------------------------+
2 rows in set (0.00 sec)
========================================================

It says that the table is corrupt. I can actually log into mysql and see the
list
of tables, but I can NOT desc or select the tables.

how do I restore the back up?
Do I need to remove the .frm files , but that would kill my data.

Thanks,

Nestor :-)
The information contained in this transmission may contain privileged and confidential
information. It is intended only for the use of the person(s) named above. If you are not
the intended recipient, you are hereby notified that any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy all copies
of the original message.


________________________________
The information contained in this transmission may contain privileged and confidential
information. It is intended only for the use of the person(s) named above. If you are not
the intended recipient, you are hereby notified that any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy all copies
of the original message.

Thread
DB/table problemNéstor10 Sep
  • RE: DB/table problemGavin Towey10 Sep
    • Re: DB/table problemTodd Lyons11 Sep
      • RE: DB/table problemGavin Towey11 Sep
    • Re: DB/table problemNéstor11 Sep
      • RE: DB/table problemGavin Towey11 Sep