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
