2006 - MySQL server has gone away - Error trying to upload database

[sunflowertami]

I am trying to upload my database from local host to live site and have followed the instructions on moving databases.

When I try to import the sql file into myphp on my live server, this is the error I get and then the import stops:

SQL query:

CREATE TABLE `admin_activity_log` (
`log_id` int( 15 ) NOT NULL AUTO_INCREMENT ,
`access_date` datetime NOT NULL default '0001-01-01 00:00:00',
`admin_id` int( 11 ) NOT NULL default '0',
`page_accessed` varchar( 80 ) COLLATE latin1_general_ci NOT NULL default '',
`page_parameters` text COLLATE latin1_general_ci,
`ip_address` varchar( 15 ) COLLATE latin1_general_ci NOT NULL default '',
PRIMARY KEY ( `log_id` ) ,
KEY `idx_page_accessed_zen` ( `page_accessed` ) ,
KEY `idx_access_date_zen` ( `access_date` ) ,
KEY `idx_ip_zen` ( `ip_address` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =7009;

MySQL said: Documentation
#2006 - MySQL server has gone away

Anybody knows what I should do to??

[DrByte]

You'll find more discussions of the same error message under "Similar Threads" below.

"2006 - MySQL server has gone away" is caused by the MySQL server connection dying while PHP or some other process is still expecting it to be open so it can continue running database commands.

You may have to work with your host to do your database import using another method, or maybe chop your import SQL file into multiple smaller files instead. Or ask your host to increase the SQL connection timeout so you can do your import.