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 :-)
