Recovering INNODB table

Using RT 3.8.7 on Fedora 8 with data in MySQL ("Ver 14.12 Distrib=20
5.0.45"). RT was working correctly for several months, though with only=20
casual use. Approximately three weeks ago, two MySQL tables started=20
reporting corruption. This was coincident with installation of NagiosQL,=20
which created a new data base, but I don't know that the two events are=20
related. Now all tables for RT report OK with mysqlcheck *except*=20
Attachments and Transactions. For those, any attempt to reference them=20
results in loss of the data base connection. Both tables are using INNODB.

# ./rt-validator -c
[Thu Feb 24 01:11:06 2011] [warning]: DBD::mysql::st execute failed:
Lost connection to MySQL server during query at ./rt-validator line
1058. (./rt-validator:1058)
[Thu Feb 24 01:11:06 2011] [crit]: DBD::mysql::st execute failed: Lost
connection to MySQL server during query at ./rt-validator line 1058.
(/opt/rt3/sbin/../lib/RT.pm:379)
DBD::mysql::st execute failed: Lost connection to MySQL server during
query at ./rt-validator line 1058.

# mysqlcheck -p --repair rt3 Attachments
Enter password:
mysqlcheck: Got error: 2013: Lost connection to MySQL server during
query when executing 'REPAIR TABLE ... '

Unfortunately, I do not have MySQL backups from before this situation.
The corrupt MySQL data base is backed-up by actual copy (cp while mysqld
was stopped). The non-corrupt tables are backed-up by mysqldump.

Is there any way to recover use of these two tables short of dropping
the entire data base and recreating? If I did that, would the mysqldump
of the remaining tables allow me to restore most content?
--
Dave Close


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg