On Thu, Apr 22, 2010 at 8:19 PM, Shawn Green <shawn.l.gr...@oracle.com> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
