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 <gabriel.preda@stripped> 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 <awfief@stripped> wrote:
> >
> > James,
> >
> > You're going to need to show us the contents of olddbname.sql.
> >
> > -Sheeri
> >
> > On 2/10/06, James Dey <james@stripped> 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
> > > >
> >
> >
>
>
