I'm trying to move a forum to another host, so i dumped up the MySQL database but I can't seem to get it to install on my new host.
Here's an example of the code in the SQL file I'm trying to upload
CREATE TABLE `bbnboard_auth_access` (
`group_id` mediumint( NOT NULL default '0',
`forum_id` smallint(5) unsigned NOT NULL default '0',
`auth_view` tinyint(1) NOT NULL default '0',
`auth_read` tinyint(1) NOT NULL default '0',
`auth_post` tinyint(1) NOT NULL default '0',
`auth_reply` tinyint(1) NOT NULL default '0',
`auth_edit` tinyint(1) NOT NULL default '0',
`auth_delete` tinyint(1) NOT NULL default '0',
`auth_sticky` tinyint(1) NOT NULL default '0',
`auth_announce` tinyint(1) NOT NULL default '0',
`auth_vote` tinyint(1) NOT NULL default '0',
`auth_pollcreate` tinyint(1) NOT NULL default '0',
`auth_attachments` tinyint(1) NOT NULL default '0',
`auth_mod` tinyint(1) NOT NULL default '0',
KEY `group_id` (`group_id`),
KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM;
I get this error using BigDump (similar error shows up in phpMyAdmin)
Error at the line 36: ) ENGINE=MyISAM;
Query: -- phpMyAdmin SQL Dump
CREATE TABLE `bbnboard_auth_access` (
`group_id` mediumint( NOT NULL default '0',
`forum_id` smallint(5) unsigned NOT NULL default '0',
`auth_view` tinyint(1) NOT NULL default '0',
`auth_read` tinyint(1) NOT NULL default '0',
`auth_post` tinyint(1) NOT NULL default '0',
`auth_reply` tinyint(1) NOT NULL default '0',
`auth_edit` tinyint(1) NOT NULL default '0',
`auth_delete` tinyint(1) NOT NULL default '0',
`auth_sticky` tinyint(1) NOT NULL default '0',
`auth_announce` tinyint(1) NOT NULL default '0',
`auth_vote` tinyint(1) NOT NULL default '0',
`auth_pollcreate` tinyint(1) NOT NULL default '0',
`auth_attachments` tinyint(1) NOT NULL default '0',
`auth_mod` tinyint(1) NOT NULL default '0',
KEY `group_id` (`group_id`),
KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM;
MySQL: You have an error in your SQL syntax near '-- phpMyAdmin SQL Dump CREATE TABLE `bbnboard_auth_access` ( `group_id` med' at line 1
although when I add this other SQL file for PhpNuke, it works fine. the syntax appears to be the same, so I don't know where the problem is!
CREATE TABLE `nuke2_access` (
`access_id` int(10) NOT NULL auto_increment,
`access_title` varchar(20) default NULL,
PRIMARY KEY (`access_id`)
) TYPE=MyISAM;
Could someone please help me!? I can't lose anything from my forum!