List:General Discussion« Previous MessageNext Message »
From:James Dey Date:February 10 2006 10:01am
Subject:RE: Migration
View as plain text  
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

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