looks like there is only a partial query
INSERT INTO `jos_banner` VALUES (1,1,'banner','OSM
1',0,46,0,'osmbanner1.png
','http://www.opensourcematters.org','2004-07-07$
there is no ending ', so when it hits the 'jos_banner
/*!40000 ALTER TABLE `jos_banner`
it sees it as the end of the field and then
basically ..
INSERT INTO `jos_banner` VALUES (1,1,'banner','OSM
1',0,46,0,'osmbanner1.png
','http://www.opensourcematters.org','2004-07-07$/*!40000 ALTER TABLE
`jos_banner
and it is choking on jos_banner as incorrect syntax
----- Original Message -----
From: "James Dey" <[EMAIL PROTECTED]>
To: "Gabriel PREDA" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
Sent: Saturday, February 11, 2006 1:52 AM
Subject: Re: Migration
Thanks!
The line is:
/*!40000 ALTER TABLE `jos_banner` */;
LOCK TABLES `jos_banner` WRITE;
INSERT INTO `jos_banner` VALUES (1,1,'banner','OSM
1',0,46,0,'osmbanner1.png
','http://www.opensourcematters.org','2004-07-07$
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_banner` ENABLE KEYS */;
For the record I had the same issue with another line, and removed the
line:
ENGINE=MyISAM DEFAULT CHARSET=latin1;
This got rid of the error
All the best!
On 2/10/06, Gabriel PREDA <[EMAIL PROTECTED]> wrote:
Not the whole... maybe it's humongous... some lines above line 20 and
some
beneath...
--
Gabriel PREDA
Senior Web Developer
On 2/10/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
>
> James,
>
> You're going to need to show us the contents of olddbname.sql.
>
> -Sheeri
>
> On 2/10/06, James Dey <[EMAIL PROTECTED]> wrote:
> > > I am migrating a database from mySQL 4.0 to 4.1.16 and have the
error
> > > ERROR 1064 at line 21: 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 'ALTER TABLE `jos_banner` */' at line 20
> > >
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
