Christopher,
InnoDB tables are in ibdata files. I hope that you have not deleted them
inadvertently.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
----- Original Message -----
From: <christopher.l.hood@stripped>
Newsgroups: mailing.database.myodbc
Sent: Thursday, January 20, 2005 5:28 AM
Subject: RE: MySQL Losing database information
> 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=A0
> Investigator Verizon Global Security Operations Center=20
> Email:=A0christopher.l.hood@stripped=20
> Desk: 972.399.5900
> Verizon Proprietary
> =09
>
>
>
> -----Original Message-----
> From: gerald_clark [mailto:gerald_clark@stripped]=20
> 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,
>>
>>=20
>>
>>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.
>>
>>=20
>>
>>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.
>>
>> =20
>>
> Try check table and repair table.
>
>> =20
>>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
