Professional Web Applications Themes

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

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

  1. #1

    Default 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
    Leonardo Guest

  2. #2

    Default Re: 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
    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 Guest

  3. #3

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

    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!




    Paul Lautman Guest

  4. #4

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

    hi,

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

    thanks

    Pradeep
    Unregistered Guest

  5. #5

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

    Quote Originally Posted by Leonardo View Post
    > 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
    bhebsquines@gmail.com Guest

  6. #6

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

    +1 on the innodb_force_recovery = 4 suggestion.

    Thank you!!!!!!
    Unregistered Guest

Similar Threads

  1. #26490 [Com]: Lost connection to MySQL server during query
    By claudelfino at hotmail dot com in forum PHP Bugs
    Replies: 1
    Last Post: December 15th, 03:46 PM
  2. Lost connection to MySQL server during query
    By Donald Tyler in forum MySQL
    Replies: 1
    Last Post: April 10th, 06:04 PM
  3. Replies: 15
    Last Post: February 26th, 11:50 PM
  4. Replies: 4
    Last Post: February 4th, 10:54 AM
  5. [PHP] Lost Connection to MySQL server during query
    By Marek Kilimajer in forum PHP Development
    Replies: 1
    Last Post: September 10th, 03:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139