mysql -u root -p ascent < /home/angel/clean_db.sql ERROR 1064 (42000) at line 4577: 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 'in LL, `Entry` int(10) unsigned NOT NULL default '0', `Map` int(10) unsigned' at line 6 DROP TABLE IF EXISTS `gameobject_spawns`; CREATE TABLE `gameobject_spawns` ( `ID` int(30) unsigned NOT NULL, `Entry` int(10) unsigned NOT NULL default '0', `Map` int(10) unsigned NOT NULL default '0', `x` float NOT NULL default '0', `y` float NOT NULL default '0', `z` float NOT NULL default '0', `Facing` float NOT NULL default '0', `o1` float NOT NULL default '0', `o2` float NOT NULL default '0', `o3` float NOT NULL default '0', `o4` float NOT NULL default '0', `State` int(10) unsigned NOT NULL default '0', `Flags` int(10) unsigned NOT NULL default '0', `Faction` int(10) unsigned NOT NULL default '0', `Scale` float NOT NULL default '0', `state_npc_link` int(30) NOT NULL, UNIQUE KEY `ID` (`ID`), KEY `Map` (`Map`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs;