List:General Discussion« Previous MessageNext Message »
From:Larry Martell Date:April 23 2010 2:56pm
Subject:Re: Loading 4.1.12 dump to 5.0.18 server
View as plain text  
On Thu, Apr 22, 2010 at 8:19 PM, Shawn Green <shawn.l.green@stripped> wrote:
> 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.

The 4.1 server does not exist any more. This is a dump from Jan 2008
that I need to load. I will have to check with the dbas at this client
and see if they can have that release and can install it somewhere.
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