MySQL Error

[box]

On Widows 2000 Advance Server with IIS
my MySQL Server working OK
When I start execute queri form a file cati.sql with SQLyog
I got this message:

Code: Select all

-- MySQL dump 9.08
--
-- Host: localhost    Database: dev_cacti_2
---------------------------------------------------------
-- Server version	4.0.14-standard

--
-- Table structure for table 'cdef'
--

CREATE TABLE cdef (
  id mediumint(8) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY ID (id),
  KEY id_2 (id)
) TYPE=MyISAM

Error : 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 '---------------------------------------------------------
-- Se

[SiRiC]

Edit the cacti.sql file and remove all the lines before

CREATE table cdef (



That should work.

[branbell]

SiRiC,

Thanks! This did the trick