Re: MySQL Losing database information
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 .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]
RE: MySQL Losing database information
Where would I find the .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]
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]