ivan at sustainablemarketing [dot] com wrote:

> I got this file from another web host. It has some syntax that I have
> not seen before. Importing it gererates an error.
>
> ERROR 1064 at line 2: 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 'ID` smallint(10) NOT NULL auto_increment,
> `County` varchar(25
>
>
> head -100 grcadmi_GRCDB-1.sql
> CREATE TABLE `12COUNTIES` (e `12COUNTIES`------------------
> `ID` smallint(10) NOT NULL auto_increment,
> `County` varchar(255) NOT NULL default '',
> `City` varchar(255) NOT NULL default '',
> PRIMARY KEY (`ID`)
> CREATE TABLE `9COUNTIES` (le
> `9COUNTIES`-------------------inos');ista');');
> `ID` smallint(10) NOT NULL auto_increment,
> `County` varchar(255) NOT NULL default '',
> `City` varchar(255) NOT NULL default '',
> PRIMARY KEY (`ID`)
> CREATE TABLE `AAE_INTAKE` (e
> `AAE_INTAKE`------------------)');ion');osta)');
> `IntakeID` int(10) NOT NULL auto_increment,
> `IntakeDate` datetime NOT NULL default '0000-00-00 00:00:00',
> `IntakeCompleted` varchar(5) NOT NULL default '',
> `ContactID` int(10) NOT NULL default '0
>
>
> specifically I think the long lines of dashes are causing the error? I
> am not sure though. Does anyone know? Is there a way to fix the file?
>

looks like the file needs some cleanup... what kind of file (mysqldump??)?


--
Michael Austin.
Database Consultant