James, You're going to need to show us the contents of olddbname.sql.
-Sheeri On 2/10/06, James Dey <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > > > -----Original Message----- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: 10 February 2006 11:58 AM > To: mysql@lists.mysql.com > 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/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]