MySQL Has Gone Away - Importing Issue Problem

Ver 3.2 revision 1129
MySQL 5

I am having an issue importing my 17 meg MySQL file on to my dedicated box.

I get the error MySQL has gone away. I would get the error on one table each time so I exported just that table (1 meg file) and I get the same error.

HeidiSQL builds the columns but no data is brought in.

I played around with some of the Target-Compatibility modes on export but 5, 5.1 and 3.2, "Same as the Source Server" still generated the same error.

I also try using Data:Insert and Data:Replace and got the same error.

The box I am importing to is a Windows 2003 Server.

Below is the beginning of the dump code (for secruity I changed the names of the columns):

# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 removed for security
# Database:             removed for security
# Server version:       5.0.54-log
# Server OS:            redhat-linux-gnu
# Target-Compatibility: MySQL 5.0
# max_allowed_packet:   16776192
# HeidiSQL version:     3.2 Revision: 1129
# --------------------------------------------------------
/*!40100 SET CHARACTER SET latin1*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/;
#
# Database structure for database 'removed for security'
#
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `removed for security` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `rentvine`;
#
# Table structure for table 'Listing'
#
CREATE TABLE /*!32312 IF NOT EXISTS*/ `Listing` (
`listingId` int(10) unsigned NOT NULL auto_increment,
`pmFk` int(10) unsigned default NULL,
`removedforsecurity` tinyint(2) unsigned NOT NULL default '0',
`removedforsecurity` varchar(60) NOT NULL default '',
`removedforsecurity` tinyint(1) unsigned NOT NULL default '0',
`removedforsecurity` tinyint(1) unsigned NOT NULL default '0',
`removedforsecurity` varchar(14) default NULL,
`removedforsecurity` varchar(14) default NULL,
`removedforsecurity` int(6) unsigned default NULL,
`removedforsecurity` int(6) unsigned default NULL,
`removedforsecurity` int(3) unsigned default NULL,
`removedforsecurity` varchar(11) default NULL,
`removedforsecurity` varchar(60) default NULL,
`removedforsecurity` varchar(60) default NULL,
`removedforsecurity` decimal(7,0) unsigned default NULL,
`removedforsecurity` decimal(6,0) unsigned default NULL,
`removedforsecurity` decimal(6,0) unsigned default NULL,
`removedforsecurity` tinyint(1) unsigned default NULL,
`removedforsecurity` tinyint(1) unsigned default NULL,
`removedforsecurity` tinyint(1) unsigned default NULL,
`removedforsecurity` tinyint(1) unsigned default NULL,
`removedforsecurity` tinyint(1) unsigned default NULL,
`removedforsecurity` tinyint(1) unsigned default NULL,
`removedforsecurity` int(2) unsigned default NULL,
`removedforsecurity` text,
`removedforsecurity` date default NULL,
`removedforsecurity` int(9) unsigned default '0',
`removedforsecurity` tinyint(2) unsigned default NULL,
`removedforsecurity` tinyint(2) unsigned default NULL,
`removedforsecurity` tinyint(2) unsigned default NULL,
`removedforsecurity` tinyint(2) unsigned default NULL,
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` tinyint(1) unsigned default '0',
`removedforsecurity` varchar(60) default NULL,
`removedforsecurity` text,
`removedforsecurity` varchar(60) default NULL,
`removedforsecurity` varchar(60) default NULL,
`removedforsecurity` varchar(60) default NULL,
`removedforsecurity` varchar(50) default NULL,
`removedforsecurity` varchar(32) default NULL COMMENT 'want it longer for the extension',
`removedforsecurity` varchar(14) default NULL,
`removedforsecurity` varchar(14) default NULL,
`onUpdateStmap` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY  (`listingId`),
KEY `L_pmFk_x` (`pmFk`)
) ENGINE=MyISAM AUTO_INCREMENT=9403 /*!40100 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='not sure on the right type'*/;
#
# Dumping data for table 'Listing'
#
TRUNCATE TABLE `Listing`;
LOCK TABLES `Listing` WRITE;
/*!40000 ALTER TABLE `Listing` DISABLE KEYS*/;
INSERT INTO `Listing` (

Any ideas why I get the error on importing?

What can I try next?

I see the table has a lot of columns. The "MySQL server has gone away" message may happen if you have a row that is larger than the max_allowed_packet value set on the server. Check if any of these docs help:

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html