Loading 4.1.12 dump to 5.0.18 server

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Loading 4.1.12 dump to 5.0.18 server

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Loading 4.1.12 dump to 5.0.18 server

On Thu, Apr 22, 2010 at 1:42 PM, 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:
>



Upgrading from an early 4.1 series to an incredibly early 5.0 series
is a bad idea. Your first priority should be upgrading your
destination to something 5.0.67 (min) or later.

--
Rob Wultsch
wultsch@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Loading 4.1.12 dump to 5.0.18 server

On Thu, Apr 22, 2010 at 8:19 PM, Shawn Green wro=
te:
> 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=3DHEAP". I changed those to ENGINE=3DMEMORY, 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.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Loading 4.1.12 dump to 5.0.18 server

On Thu, Apr 22, 2010 at 9:39 PM, Rob Wultsch wrote:
> On Thu, Apr 22, 2010 at 1:42 PM, 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:
>>
> Upgrading from an early 4.1 series to an incredibly early 5.0 series
> is a bad idea. Your first priority should be upgrading your
> destination to something 5.0.67 (min)  or later.

They are not upgrading anything. They have a dump from Jan 2008 that
they want me to look at and do some analysis on. In Jan 2008 they were
running 4.1.12. Today they are running 5.0.18. This is not something
that I have control over. This is at a client site.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg