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:[EMAIL PROTECTED]
Desk: 972.399.5900
Verizon Proprietary
-----Original Message-----
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 18, 2005 8:05 AM
To: Christopher L. Hood
Cc: mysql@lists.mysql.com
Subject: Re: MySQL Losing database information
[EMAIL PROTECTED] 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.
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
