From: Néstor
Date: September 10 2009 11:34pm
Subject: Re: DB/table problem
List-Archive: http://lists.mysql.com/mysql/218693
Message-Id: <a304e2d60909101634s13415cecufd6400ce0bd0df9a@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001636b2bca0014c5a047341a525

--001636b2bca0014c5a047341a525
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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.  Copyin=
g
> 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=E9stor [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 t=
he
> data directory:
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
> 090910 11:04:03090910 11:04:03 [ERROR] Cannot find table scroller612/cach=
e
> 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.
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D
>
> When I go to the above link it saids to run the "check table" statement,
> but when I do this, I get below response:
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D
> 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)
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D
>
> 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 notifi=
ed
> that any review, dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the intended recipie=
nt,
> please contact the sender by reply email and destroy all copies of the
> original message.
>

--001636b2bca0014c5a047341a525--