Old DB
Quote:
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:
Quote:
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)
10-05-2006, 05:42 AM
Change hosting and restore DB error
Linear Mode
