RE: MySQL Losing database information

[christopher.l.hood]

Where would I find the <tablename>.InnoDB files ?
As in the error below that I receive when check table is run against the
table:

mysql> check table ACL;
+---------+-------+----------+-------------------------------------------+
| Table   | Op    | Msg_type | Msg_text                                  |
+---------+-------+----------+-------------------------------------------+
| rt3.ACL | check | error    | Can't open file: 'ACL.InnoDB'. (errno: 1) |
+---------+-------+----------+-------------------------------------------+
1 row in set (0.01 sec)



Chris Hood 
Investigator Verizon Global Security Operations Center 
Email: christopher.l.hood@stripped 
Desk: 972.399.5900
Verizon Proprietary
		



-----Original Message-----
From: gerald_clark [mailto:gerald_clark@stripped] 
Sent: Tuesday, January 18, 2005 8:05 AM
To: Christopher L. Hood
Cc: mysql@stripped
Subject: Re: MySQL Losing database information



christopher.l.hood@stripped wrote:

>ALL,
>
> 
>
>I have an issue where MySQL has lost all of the table information for an
>existing database, I do not know of anything that has changed and there
>was no maintenance being done in MySQL. Below you will find the error
>message as I receive it from MySQL.
>
> 
>
>ANY ideas or suggestions on how to recover this database intact will be
>GREATLY appreciated. The " .FRM " files are intact and all permissions
>have been checked against a database that I CAN still access, which tells
>me that the problem is the database somehow and not MySQL as a whole.
>
>  
>
Try check table and repair table.

>  
>