Errors in MySQL DB uploading via phpMyadmin
I'm facing a critical problem here...I'm using MySQL 4.1.7 and myphpadmin 2.6.0-pl3 on my PC (xammp). I am converting my database to .sql via phpmyadmin and upload to the server.
However, there are errors that tell me to check version number etc....How can i overcome this? The server is using:
MySQL 4.0.22
phpmyadmin 2.6.1-pl2
Is it a must to match these two versions when uploading of .sql is concern?
The current error is:
#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=66' at line 27
and line 27:
PHP Code:
CREATE TABLE `admin_activity` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 10 ) NOT NULL default '',
`login` timestamp NOT NULL default '0000-00-00 00:00:00',
`logout` datetime default '0000-00-00 00:00:00',
`reason` varchar( 50 ) NOT NULL default '',
`log_file` text NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =66 //line 27
