Restore 4.1 Tables to 4.0 System

I am new to MySQL and I'm trying to Backup/Restore database tables from my
4.1.10 MySQL server which is located on my local machine to my database on
my ISP's 4.0.17 server. However, when I try to do the restore I get a very
general error: "MySQL Error Nr. 1064-You have an error in your SQL syntax"
which leaves me without a clue as to what the real problem is.

Following is an example of 1 of the tables created using the Backup function
on my 4.1.10 system.

SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;

USE `MyDatabase`;
CREATE TABLE `tblemployees` (
`empID` int(10) unsigned NOT NULL auto_increment COMMENT 'Primary Key',
`empFirstName` varchar(45) NOT NULL default '',
`empLastName` varchar(45) NOT NULL default '',
`empStreet1` varchar(45) default NULL,
`empStreet2` varchar(45) default NULL,
`empCity` varchar(45) default NULL,
`empState` char(2) default NULL,
`empZip` varchar(10) default NULL,
`empPhone` varchar(15) default NULL,
`empCellPhone` varchar(15) default NULL,
`empSSnumber` varchar(11) default NULL,
`empStartDate` date NOT NULL default '0000-00-00',
`empTerminationDate` date default '0000-00-00',
`empTitle` varchar(45) NOT NULL default '',
PRIMARY KEY (`empID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Employee Table';

INSERT INTO `tblemployees`
(`empID`,`empFirstName`,`empLastName`,`empStreet1`,`empStree t2`,`empCity`,`e
mpState`,`empZip`,`empPhone`,`empCellPhone`,`empSSnumber`,`e mpStartDate`,`em
pTerminationDate`,`empTitle`) VALUES
(1,'John','Doe','123 Fourth
Ave',NULL,'Portland','OR','95432','503-123-4567','503-123-98 76','123-45-6789
','2005-03-01','0001-01-01','Driver'),
(2,'Mary','Williams','1510 Center','Apt. 123','Oregon
City','OR','97045','503-432-9876','503-111-2222','111-22-333 3','2005-03-01',
'0000-00-00','Driver'),
(3,'David','O\'Reily','1120 Garden Blvd','Apt
#6','Portland','OR','93214','503-123-9011',NULL,'111-22-3333 ','2005-03-09',N
ULL,'Driver'),
(4,'Mike','Smith','1520 Oak
Ave',NULL,'Portland',NULL,NULL,NULL,NULL,NULL,'2005-03-01',N ULL,'Driver');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;



Thank you for any and all replys

Vic


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org