At 01:18 PM 4/30/2012 +0800, Nadel Catura wrote:
Oh no. :( This is not good. But, we suspect that the problem is on the InnoDB. Do you know any procedure to repair InnoDB?
See <http://dev.mysql.com/doc/refman/5.0/en/forcing-innodb-recovery.html> and pay particular attention to the values 1 to 4 (backup, start low and backup every time.).
we have found out that the database (structure) is intact. However, the data (ibdata1) is corrupted. Do we have a way to repair it?
I have successfully recovered from failures as described (any previous corruption of *data* will not be fixed.) Lessons: you never have too many backups and innodb can be sensitive to insipid HD failure - consider a RAIDed setup. Also note that this email is not technical advice, and I take no responsibility whatsoever for success or failure.
Paul
On Mon, Apr 30, 2012 at 12:35 PM, Robin Sheat <ro...@catalyst.net.nz> wrote: > Nadel Catura schreef op ma 30-04-2012 om 12:32 [+0800]: > > see attached file. That's the farthest i can get on syslog. > > > > > > the error first occured last thursday, April 26, around 11am. but the > > log on that specific date is not included in the file anymore. > > You have a disk that's failing. I'd recommend finding someone local who > specialises in that kind of thing to help. It's a bit beyond what we can > reliably do via mailing list. > > -- > Robin Sheat > Catalyst IT Ltd. > â +64 4 803 2204 > GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D > -- Have a nice day!* âºâºâºâºâºâº Nadel D. Catura* *System Developer* *Information Technology Office *De La Salle Canlubang Leandro V. Locsin Campus, Biñan, Laguna 4024 (+632) 666-4465 or 666-452 loc. 112 http://www.dlsc.edu.ph/ *--------------------------------------------------------------------------- Please consider the environment before printing this email. - a reminder from DLSC ITC* *--------------------------------------------------------------------------- * _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
--- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
