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

[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

[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!!!

[Paul Lautman]

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!

[Unregistered]

hi,

This worked for me ..... Thanks for your help..
G8 going ....

thanks

Pradeep

[bhebsquines@gmail.com]

> Hi to everybody,

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!!!

Thanks, work on me.

for mysql 5.0.67

add this line to /etc/mysql/my.cnf

find [mysqld] under

add this line innodb_force_recovery = 4