List:General Discussion« Previous MessageNext Message »
From:Néstor Date:September 10 2009 6:27pm
Subject:DB/table problem
View as plain text  
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 :-)

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