I'm assuming that I'm having problems with my export from 3.23 that I'm importing into 4.1 (for full support and compatibility), since I am having errors pop up on import. Here's the error that I'm getting:

#1064 - 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 '' at line 8

Line 8 in the SQL file is just a comment about the PHP version, I don't see anything wrong. I'm thinking it's due to all the special characters not being escaped correctly within the data, but that's just a guess.

I'm confused. An MT exports from that version wouldn't be SQL, so this error makes no sense. Are you talking about a database dump(like from PHPMyAdmin)? I'm not sure how much help we can be here regarding that if it's the case.