List:General Discussion« Previous MessageNext Message »
From:sheeri kritzer Date:February 10 2006 3:09pm
Subject:Re: Migration
View as plain text  
James,

You're going to need to show us the contents of olddbname.sql.

-Sheeri

On 2/10/06, James Dey <james@stripped> wrote:
> Sure, I just use "mysql db name < olddbname.sql
>
> Regards,
>
> James Dey
>
> tel     +27 11 704-1945
> cell    +27 82 785-5102
> fax     +27 11 388-8907
> mail    james@stripped
>
>
> -----Original Message-----
> From: Martijn Tonies [mailto:m.tonies@stripped]
> Sent: 10 February 2006 11:58 AM
> To: mysql@stripped
> Subject: Re: Migration
>
>
> > 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
> >
> >
> >
> > Could anyone perhaps let me know how I can remedy this,
>
> Care to show the full statement?
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
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