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.
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
Address: 14 Leslie Hough Way
Tel: 0870-160-0650 Ext 201
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.From: email@example.com
[mailto:firstname.lastname@example.org] On Behalf Of Ruslan
Sent: 09 March 2011 21:57
To: CLOSE Dave
Subject: Re: [rt-users] Recovering RT data base
You should look into Innodb recovery manuals.
Also, you should look at mysql logs for more info.
And it’s really better to move forward to mysql forums/lists for help.
Using RT 3.8.7 on Fedora 8 with data in MySQL. RT was working
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
but I don’t know that the two events are related. Now all tables for
report OK with mysqlcheck except Attachments and Transactions. For
those, any attempt to reference them results in loss of the data base
[Thu Feb 24 01:11:06 2011] [warning]: DBD::mysql::st execute failed:
Lost connection to MySQL server during query at ./rt-validator line
[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.
DBD::mysql::st execute failed: Lost connection to MySQL server during
query at ./rt-validator line 1058.
mysqlcheck -p --repair rt3 Attachments
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
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
of the remaining tables allow me to restore most content?
Best regards, Ruslan.