importing a 4.1 database into 4.0

[Sascha Adler]

hello,

I'm having some trouble importing a database from 4.1.11 into 4.0.20. previously, I managed to import it into a 4.0.18 instance of MySQL but the changes I made to get it to work don't work for 4.0.20 for some reason. the error message I get looks something like this:

--

ERROR 1064 at line 22: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE=MyISAM' at line 5

--

and the .sql file for the database starts like this:

--

# MySQL-Front 3.2 (Build 6.11)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES 'utf8' */;

# Host: localhost Database: glossary_db
# ------------------------------------------------------
# Server version 4.1.11-log

--DROP DATABASE IF EXISTS `glossary_db`;
--CREATE DATABASE glossary_db /*!40100 DEFAULT CHARACTER SET latin1 */;
USE glossary_db;
/*!40101 SET NAMES latin1 */;


#
# Table structure for table glossary_type
#

CREATE TABLE `glossary_type` (
`type_id` tinyint(3) unsigned NOT NULL default '0',
`type_name` varchar(100) NOT NULL default '',
PRIMARY KEY (`type_id`),
) ENGINE=MyISAM;

--

can anyone figure out the issue?