[Koha] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

[Paul]

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 <robin at 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 at 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>