List:General Discussion« Previous MessageNext Message »
From:George Law Date:February 11 2006 3:01pm
Subject:Re: Migration
View as plain text  
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" <james@stripped>
To: "Gabriel PREDA" <gabriel.preda@stripped>
Cc: <mysql@stripped>
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 <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