Change hosting and restore DB error [Archive]

thptquynhluu1

10-05-2006, 05:42 AM

Old DB
DROP TABLE IF EXISTS access;
CREATE TABLE `access` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`accessmask` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`forumid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
...
..

Moved hosting to 1and1.com, restore DB whith bigdump.php, error:

Error at the line 7: ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query: CREATE TABLE `access` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`accessmask` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`forumid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

MySQL: 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=utf8' at line 6
??? HELP ME! (Data 30MB)