Just to chip in with this one, chances are that the corruption is down to a hard disk problem of some sort. MySQL only tends to corrupt (assuming innodb), if you messed with the innodb engine settings during the install of NagioSQL or a underlying HDD issue. At which point MySQL will have binlogs it struggles with and a world of other problems. Check for changes to my.cnf and dmesg for kernel messages regarding the disc.
Kind Regards, Find Vaioni's latest Terms and Conditions & SLA docs http://www.vaioni.com/tcaupsla.html. http://www.vaioni.com/ http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibitor_285 http://www.cbawards.co.uk/Reader_Vote_3.cfm http://www.vaioni.com/ Matthew Hattersley Email: mailto:matthew.hatters...@vaioni.com Mobile: Address: 14 Leslie Hough Way Manchester Lancashire M6 6AJ Tel: 0870-160-0650 Ext 201 Fax: 0870-160-0651 Web: http://www.vaioni.com http://www.convergencesummit.co.uk/Exhibitor_List_North.cfm#Exhibitor_285 The information transmitted in and with this email is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the Company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. Please also note, Vaioni filter incoming email for spam and inappropriate words. Unfortunately this does mean that sometimes genuine messages can be filtered out. Although we take measures to recover such messages, it must not be assumed that an email has been received by us and important communications should always be followed up by a phone call, fax or printed copy. -----Original Message----- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Ruslan Zakirov Sent: 09 March 2011 21:57 To: CLOSE Dave Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Recovering RT data base You should look into Innodb recovery manuals. http://dev.mysql.com/doc/refman/5.0/en/innodb-recovery.html Also, you should look at mysql logs for more info. And it's really better to move forward to mysql forums/lists for help. On Wed, Mar 9, 2011 at 10:31 PM, CLOSE Dave <dave.cl...@us.thalesgroup.com> wrote: > Using RT 3.8.7 on Fedora 8 with data in MySQL. RT was working correctly > for several months, though with only casual use. Approximately three > weeks ago, two MySQL tables started reporting corruption. This was > coincident with installation of NagiosQL, which created a new data base, > but I don't know that the two events are related. Now all tables for RT > report OK with mysqlcheck *except* Attachments and Transactions. For > those, any attempt to reference them results in loss of the data base > connection. > > # ./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 > > -- Best regards, Ruslan.