ERROR 2013 (HY000): Lost connection to MySQL server during query

Hi to everybody,

I have upgrade to mysql 5.0.18 my linux box and when I'm trying to make
any command in this table:
select * from PROGETTO;
ERROR 2013 (HY000): Lost connection to MySQL server during query

PROGETTO use the INNODB engine.

mysqlcheck of all table return OK

Can anyone help me?

Thanks in advance for any help,


Leonardo

> Hi to everybody,
>
> I have upgrade to mysql 5.0.18 my linux box and when I'm trying to make
> any command in this table:
> select * from PROGETTO;
> ERROR 2013 (HY000): Lost connection to MySQL server during query
>
> PROGETTO use the INNODB engine.
>
> mysqlcheck of all table return OK
>
> Can anyone help me?
>
> Thanks in advance for any help,
>
>
> Leonardo

I have solved my problem with this step:
- stop mysql
- make /etc/my.cnf with this line:
[mysqld]
innodb_force_recovery = 4

- mysqldump to a file (I have recovered not all table but a lot of it!)
- upgrade mysql to 5.0.21 (server, client, devel)
- substitute every engine InnoDb to MyIsam
- restore DB from sql file

Zope 2.8.6 now work correctly!

So if you must upgrade Mysql have a look to InnoDb engine!


Leonardo

P.S.:
I'm so sorry for my bad english!!!

Leonardo wrote:
> Leonardo
>
> P.S.:
> I'm so sorry for my bad english!!!

Don't worry about it. It's English people's bad english that really annoys!