Re: Loading 4.1.12 dump to 5.0.18 server

2010-04-23 Thread Larry Martell
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 id

Re: Loading 4.1.12 dump to 5.0.18 server

2010-04-23 Thread Larry Martell
On Thu, Apr 22, 2010 at 8:19 PM, Shawn Green 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 M

Re: Loading 4.1.12 dump to 5.0.18 server

2010-04-22 Thread Rob Wultsch
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 t

Re: Loading 4.1.12 dump to 5.0.18 server

2010-04-22 Thread Shawn Green
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`,

Loading 4.1.12 dump to 5.0.18 server

2010-04-22 Thread Larry Martell
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`