Re: MySQL Losing database information

[Heikki Tuuri]

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: <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
Desk: 972.399.5900
Verizon Proprietary
=09

-----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,
=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/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]