导入数据库时出现 Errno.: 1193 的解决方法

我的也是啊
快啊
Discuz! info: MySQL Query Error

User: admin
Time: 2006-11-25 4:27pm
Script: /admincp.php

SQL: CREATE TABLE `cdb_access` ( `uid` mediumint(8) unsigned NOT NULL default '0', `fid` smallint(6) unsigned NOT NULL default '0', `allowview` tinyint(1) NOT NULL default '0', `allowpost` tinyint(1) NOT NULL default '0', `allowreply` tinyint(1) NOT NULL default '0', `allowgetattach` tinyint(1) NOT NULL default '0', `allowpostattach` tinyint(1) NOT NULL default '0', PRIMARY KEY (`uid`,`fid`)) ENGINE=MyISAM DEFAULT CHARSET=gbk
Error: 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=gbk' at line 1
Errno.: 1064

Discuz! info: MySQL Query Error

User: uuloo
Time: 2006-11-26 12:14am
Script: /admincp.php

SQL: CREATE TABLE `cdb_sessions` ( `sid` char(6) character set gbk collate gbk_bin NOT NULL default '', `ip1` tinyint(3) unsigned NOT NULL default '0', `ip2` tinyint(3) unsigned NOT NULL default '0', `ip3` tinyint(3) unsigned NOT NULL default '0', `ip4` tinyint(3) unsigned NOT NULL default '0', `uid` mediumint(8) unsigned NOT NULL default '0', `username` char(15) NOT NULL default '', `groupid` smallint(6) unsigned NOT NULL default '0', `styleid` smallint(6) unsigned NOT NULL default '0', `invisible` tinyint(1) NOT NULL default '0', `action` tinyint(1) unsigned NOT NULL default '0', `lastactivity` int(10) unsigned NOT NULL default '0', `lastolupdate` int(10) unsigned NOT NULL default '0', `pageviews` smallint(6) unsigned NOT NULL default '0', `seccode` smallint(6) unsigned NOT NULL default '0', `fid` smallint(6) unsigned NOT NULL default '0', `tid` mediumint(8) unsigned NOT NULL default '0', `bloguid` mediumint(8) unsigned NOT NULL default '0', UNIQUE KEY `sid` (`sid`), KEY `uid` (`uid`), KEY `bloguid` (`bloguid`)) ENGINE=HEAP DEFAULT CHARSET=gbk MAX_ROWS=65535
Error: 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 'collate gbk_bin NOT NULL default '', `ip1` tinyint(3) unsigned
Errno.: 1064

就只导入了第一分卷

Discuz! info: MySQL Query Error

User: 泰山
Time: 2006-12-8 10:05am
Script: /admincp.php

SQL: SET NAMES 'gbk'
Error: Unknown system variable 'NAMES'
Errno.: 1193

Similar error report has beed dispatched to administrator before.

其他还是这样  那些字符都替换完了

郁闷死

成功了 谢谢了

SQL: SET NAMES 'utf8'
Error: Unknown system variable 'NAMES'
Errno.: 1193


这样的呢!这样的好象更换了,不可以用啊!!

Discuz! info: MySQL Query Error

User: sharetm
Time: 2006-12-12 3:28pm
Script: /bbs/admincp.php

SQL: CREATE TABLE `cdb_bbcodes` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `available` tinyint(1) NOT NULL default '0', `tag` varchar(100) NOT NULL default '', `icon` varchar(255) NOT NULL default '', `replacement` text NOT NULL, `example` varchar(255) NOT NULL default '', `explanation` text NOT NULL, `params` tinyint(1) unsigned NOT NULL default '1', `nest` tinyint(3) unsigned NOT NULL default '1', PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=gbk AUTO_INCREMENT=8
Error: 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=gbk AUTO_INCREMENT=8' at line 1
Errno.: 1064

啊哈！好文！真是太好了

Unknown system variable 'NAMES'

还是错误  希望有人能帮忙解决

  改过了，但还是不行，我的也是1064的错误！！
Discuz! info: MySQL Query Error

User: admin
Time: 2007-1-5 1:59am
Script: /bbs/admincp.php

SQL: CREATE TABLE `cdb_advertisements` ( `advid` mediumint(8) unsigned NOT NULL auto_increment, `available` tinyint(1) NOT NULL default '0', `type` varchar(50) NOT NULL default '0', `displayorder` tinyint(3) NOT NULL default '0', `title` varchar(50) NOT NULL default '', `targets` text NOT NULL, `parameters` text NOT NULL, `code` text NOT NULL, `starttime` int(10) unsigned NOT NULL default '0', `endtime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`advid`)) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=gbk AUTO_INCREMENT=18
Error: 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=gbk AUTO_INCREMENT=18' at line 1
Errno.: 1064

我就是这个问题哈  谢了~  还在替换 哎  数据太大了 替换半天 卡死

顶你先~:)