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]
