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 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:rot...@gmail.com] > Sent: Thursday, September 10, 2009 11:28 AM > To: mysql@lists.mysql.com > 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. >
