List:General Discussion« Previous MessageNext Message »
From:Néstor Date:September 10 2009 11:34pm
Subject:Re: DB/table problem
View as plain text  
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> 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]
> Sent: Thursday, September 10, 2009 11:28 AM
> To: 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.
>

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