hi, just moving my forum to another host. trying to import my database using phpmyadmin (mysql 5+ as it was from original host).can anyone advise on a fix please. tia.


Error

SQL query:

-- MyBB Database Backup
-- Generated: 04th March 2009 at 19:13
------------------------------------- --
CREATE TABLE `mybb_adminlog` (
`uid` int( 10 ) unsigned NOT NULL default '0',
`dateline` bigint( 30 ) NOT NULL default '0',
`scriptname` varchar( 50 ) NOT NULL default '',
`action` varchar( 50 ) NOT NULL default '',
`querystring` varchar( 150 ) NOT NULL default '',
`ipaddress` varchar( 50 ) NOT NULL default '',
KEY `scriptname` ( `scriptname` , `action` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation
#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 '---------------------------------------

CREATE TABLE `mybb_adminlog` (
`uid` ' at line 1