I've inheritied a mysql dump from a 3.23 database. The appliance I'm supposed to reload it on is a 4.1 mysql database. it's bombing out on me, which really doesn't surprise me. However, I'm wondering if there is a script out there that will go through and check the syntax of the .sql file and convert any 'non 4x' statements into something that 4.1 can understand and like.
It's not a giant DB, it's about 250kb - but that's a lot of flat text to have to go bumbling though since I'm not really sure what the differences are. The error I'm running into is this:
ERROR 1064 (42000) at line 286: 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 'version(version),
KE' at line 36