MySQL 1064 Error

I’m transfering several WP databases from one Host to another. When I export my database from the old server (PHPMyAdmin version 2.6.0, MySQL Version 3.23.58) and try to import it onto my new server(PHPMyAdmin 7, MySQL 4.1.21), I am greeted with this error message:

#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 ‘id` int(11) NOT NULL auto_increment,
ip text NOT NULL,
date datetime NOT’ at line 1

I’ve made several calls and have spent hours looking on support forms but haven’t had any luck. I’ve seen some people with similar problems here, so I figured I’d give it a shot. Any help would be greatly appreciated.