From: Eric Bergen
Date: December 31 2004 12:09am
Subject: Re: export from older version
List-Archive: http://lists.mysql.com/mysql/177903
Message-Id: <11b1bd9904123016097fa15fba@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

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 <mysql@stripped> 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/mysql?unsub=eric.bergen@stripped
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
http://www.bleated.com