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 > > > > > > > > > >
