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
>> 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?
> 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.