From: Shawn Green
Date: April 23 2010 2:19am
Subject: Re: Loading 4.1.12 dump to 5.0.18 server
List-Archive: http://lists.mysql.com/mysql/221390
Message-Id: <4BD103C2.80407@oracle.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Larry Martell wrote:
> I need to load a dump from a 4.1.12 server to a 5.0.18 server. When I
> do that it fails with:
> 
> ERROR 1064 (42000) at line 23: 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 'BTREE
> (`bookId`,`productId`,`clusterId`,`symbolId`),
> KEY `symbolId` TYPE BTREE' at line 37
> 
> I did use sed to get rid of those lines, but then I hit a problem with
> lines that had "ENGINE=HEAP". I changed those to ENGINE=MEMORY, then I
> hit another problem. I certainly could iteratively do this until I get
> it to load, but I'm wondering if anyone knew of a better solution for
> this? Is the some tool that will convert the dump?
> 
> TIA!
> -larry
> 

Have you tried dumping the data with the mysqldump from the 5.1 package? 
  It should be able to connect just fine to the 4.1 instance and its 
output is already 5.1 compatible.

-- 
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN