List:General Discussion« Previous MessageNext Message »
From:Shawn Green Date:April 23 2010 2:19am
Subject:Re: Loading 4.1.12 dump to 5.0.18 server
View as plain text  
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
Thread
Loading 4.1.12 dump to 5.0.18 serverLarry Martell22 Apr
  • Re: Loading 4.1.12 dump to 5.0.18 serverShawn Green23 Apr
    • Re: Loading 4.1.12 dump to 5.0.18 serverLarry Martell23 Apr
  • Re: Loading 4.1.12 dump to 5.0.18 serverRob Wultsch23 Apr
    • Re: Loading 4.1.12 dump to 5.0.18 serverLarry Martell23 Apr