[mikenune]

OK, when I try to source the Velious PEQ DB (clean dump, no other files sourced), it works fine until it tries to make the "spawn2" table, where it gives me the following error:

The reason it says the error is at line 13 is because I cut the load_system.sql dump into 2 files with the second file starting at the creation of the "spawn2" table (so I could make sure everything else sourced fine).

ERROR 1064 (42000): 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 'condition mediumint(8) unsigned NOT NULL default '0',
  cond_value mediumint(9)' at line 13

Here's the beginning of the file I'm trying to source in (load_system.b.sql):

-- MySQL dump 9.11
--
-- Host: 127.0.0.1    Database: peq_velious
-- ------------------------------------------------------
-- Server version	4.0.22

--
-- Table structure for table `spawn2`
--

CREATE TABLE spawn2 (
  id int(11) NOT NULL auto_increment,
  spawngroupID int(11) NOT NULL default '0',
  zone varchar(16) NOT NULL default '',
  x float(14,6) NOT NULL default '0.000000',
  y float(14,6) NOT NULL default '0.000000',
  z float(14,6) NOT NULL default '0.000000',
  heading float(14,6) NOT NULL default '0.000000',
  respawntime int(11) NOT NULL default '0',
  variance smallint(4) NOT NULL default '0',
  pathgrid int(10) NOT NULL default '0',
  timeleft bigint(16) NOT NULL default '0',
  condition mediumint(8) unsigned NOT NULL default '0',
  cond_value mediumint(9) NOT NULL default '1',
  PRIMARY KEY  (id),
  KEY ZoneGroup (zone,spawngroupID)
) TYPE=MyISAM;

an exact copy of what I typed into the MySQL Command Line:

CREATE DATABASE eq;
USE eq
SOURCE load_empty_users.sql;
SOURCE load_system.a.sql;
SOURCE load_system.b.sql;

The load_empty_users.sql file works perfectly.

The load_system.a.sql is the first half of the original load_system.sql file and covers tables "aa_actions" through "pets". This file sources without error.

The load_system.b.sql is the second half (and is only a 10MB file whereas the other one is 87MB - so I know it's not some weird file size issue) and covers "spawn2" through "zoneserver_auth". It, of course, gives the above error and is completely unable to dump the "spawn2" table. When I remove all the "spawn2" entries from the file, all the other tables in here source correctly.

Could it be a problem with "condition" being a keyword in MySQL 5?