List:General Discussion« Previous MessageNext Message »
From:James Dey Date:February 11 2006 6:52am
Subject:Re: Migration
View as plain text  
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
> > > >
> >
> >
>
>
Thread
MigrationJames Dey10 Feb
  • Re: MigrationMartijn Tonies10 Feb
    • RE: MigrationJames Dey10 Feb
      • Re: Migrationsheeri kritzer10 Feb
        • Re: MigrationGabriel PREDA10 Feb
          • Re: MigrationJames Dey11 Feb
    • Re: MigrationGeorge Law11 Feb