Simple Machines Community Forum

Trying to move sites and databases, and I keep running into this problem.

Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 40
STR: =;
SQL:

CREATE TABLE `smf_moderators`
) TYPE=;


SQL query:

CREATE TABLE `smf_moderators` ) TYPE=;

MySQL said: 

#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 ') TYPE=' at line 2



Here's the code around the 'problem area'.

# --------------------------------------------------------

#
# Table structure for table `smf_moderators`
#

DROP TABLE IF EXISTS `smf_moderators`;

CREATE TABLE `smf_moderators`
) TYPE=;

#
# Table structure for table `smf_package_servers`
#

DROP TABLE IF EXISTS `smf_package_servers`;

CREATE TABLE `smf_package_servers`
) TYPE=;

#
# Table structure for table `smf_permissions`
#

DROP TABLE IF EXISTS `smf_permissions`;

CREATE TABLE `smf_permissions`
) TYPE=;

#
# Table structure for table `smf_personal_messages`
#

DROP TABLE IF EXISTS `smf_personal_messages`;

CREATE TABLE `smf_personal_messages`
) TYPE=;

#
# Table structure for table `smf_pm_recipients`
#

DROP TABLE IF EXISTS `smf_pm_recipients`;

CREATE TABLE `smf_pm_recipients`
) TYPE=;

#
# Table structure for table `smf_poll_choices`
#

DROP TABLE IF EXISTS `smf_poll_choices`;

CREATE TABLE `smf_poll_choices`
) TYPE=;

#
# Table structure for table `smf_polls`
#

DROP TABLE IF EXISTS `smf_polls`;

CREATE TABLE `smf_polls`
) TYPE=;

#
# Table structure for table `smf_sessions`
#

DROP TABLE IF EXISTS `smf_sessions`;

CREATE TABLE `smf_sessions`
) TYPE=;

#
# Table structure for table `smf_settings`
#

DROP TABLE IF EXISTS `smf_settings`;

CREATE TABLE `smf_settings`
) TYPE=;

#
# Table structure for table `smf_smileys`
#

DROP TABLE IF EXISTS `smf_smileys`;

CREATE TABLE `smf_smileys`
) TYPE=;

#
# Table structure for table `smf_themes`
#

DROP TABLE IF EXISTS `smf_themes`;

CREATE TABLE `smf_themes`
) TYPE=;

#
# Table structure for table `smf_topics`
#

DROP TABLE IF EXISTS `smf_topics`;

CREATE TABLE `smf_topics`
) TYPE=;

# Done

Help would be appreciated. =)

This SQL is trunked. Why do you run SQL queries and dont backup/restore?
Its very easier. Just setup a new forum where you want to move your site to.
Then take a backup of old forum, and restore onto new one.. Thats all.