error importing from mysqldump output

[Russell E Glaue]

I did a mysqldump from serverA, took that output and did the following 
as illustrated below to import into serverB.
why did I get an error?

Did mysqldump output the wrong SQL syntax?  I would not think so, but I 
got this error which says so.

I am using mysql-4.0.20 on both servers.
I am importing with "skip-grant-tables" option, and no databases 
(including no mysql database).

daemon0% mysqldump -S mysqld-daemon0.sock --master-data --all-databases 
> daemin0-dump.sql

daemon1% mysql -S /tmp/mysqld-daemon1.sock < /tmp/daemon0-dump.sql
ERROR 1064 at line 14071: 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 'order int(1) NOT NULL default '0',
  PRIMARY KEY  (moduleID),

CREATE TABLE modules (
  moduleID varchar(10) NOT NULL default '',
  moduleName varchar(50) NOT NULL default '',
  order int(1) NOT NULL default '0',
  PRIMARY KEY  (moduleID),
  UNIQUE KEY moduleID (moduleID)
) TYPE=MyISAM COMMENT='List of all Modules';

Would this possibly be a bug with mysqldump ?
-RG
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]