error 2006 (Mysql sever gone away)

[Ken Iovino]

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 Password: **********
(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?

[Steve Machol]

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