error 2006 (Mysql sever gone away)

Filed Under zjbr.com |

  • ERROR 2006 at line 7908: MySQL server has gone away

    Okay this is the error im getting when attemping to restore a database on my server. The database is only 20,200kb. And i've restored a database on the server last week that was over 532,849kb. So im kinda lost.

    Heres what i do:
    I type

    mysql -u myusername -p dbname < 07-30-04.sql
    Enter **********
    (10 seconds go bye)
    ERROR 2006 at line 7908: MySQL server has gone away


    So after trying a few times i looked into the database to see what it put in there, or if anything at all went into the database. And heres what goes into the database.


    access
    adminhelp
    administrator
    adminlog
    adminutil
    adv_modules
    adv_pages
    adv_setting
    adv_settinggroup
    announcement
    attachment


    And thats where it stops. After doing a search here i found how to change my settings in the my.cnf file. Heres what its set too.

    #set-variable = innodb_lock_wait_timeout=5000
    set-variable = max_allowed_packet=100M

    MySQL version: 8.23
    Server version: 3.23..47-nt
    Protocol version: 10
    uptime: 1 day 10 hours 29 mins 32 secs

    Any ideas whats going on?


  • This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:

    http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about error 2006 (Mysql sever gone away) , Please add it free.

    Comments