If you can use mysqldump to export the data from 3.23 with the -Q switch to quote all db, table, and column names.
On Thu, 30 Dec 2004 11:31:42 -0800, Don Stefani <[EMAIL PROTECTED]> wrote: > Hello, > > I am trying to import a table structure from ver 3.23.52 to ver > 4.1.7-max and I am getting an error: > > ----------- error --------- > > |#1064 - 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 'wish_list_id` int(6) NOT NULL auto_increment, > `Client_Name` varchar(255) defau' at line 2 > > ----- end -------- > > I am using phpMyAdmin to do the export, and I have tried using it and > mysql> source to run the file but I get the same error from both. > > You help would be appreciated. > > Thanks, > > - dstefani > | > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
