不同MYSQL版本数据导入问题解决办法

占位

找不到 ENGINE=HEAP DEFAULT CHARSET=latin1

dz4也一样？

Discuz! info: MySQL Query Error

User: admin
Time: 2005-12-18 5:19pm
Script: /main.php

SQL: SELECT subject ,message FROM cdb_posts where tid=
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 '' at line 1
Errno.: 1064

An error report has been dispatched to our administrator.

我的没有提示什么错误，很顺利的就导入了，但是完成后，论坛的中文就变成问好了

请问，这是什么原因？

我发帖子了,可是没人给答案,

http://www.zztx.be/
http://zztx.globalfreeweb.com/
用的是一个空间,为什么会这样呢
显示一个是2.5一个是4.0  
为什么会这样呢?怎么解决啊

Discuz! info: MySQL Query Error

User: vivi
Time: 2006-1-1 1:48pm
Script: /admincp.php

SQL: CREATE TABLE `cdb_forums` ( `fid` smallint(6) unsigned NOT NULL auto_increment, `fup` smallint(6) unsigned NOT NULL default '0', `type` enum('group','forum','sub') NOT NULL default 'forum', `name` varchar(255) NOT NULL default '', `cates` varchar(150) NOT NULL default '_所有文章', `status` tinyint(1) NOT NULL default '0', `displayorder` tinyint(3) NOT NULL default '0', `styleid` smallint(6) unsigned NOT NULL default '0', `threads` mediumint(8) unsigned NOT NULL default '0', `posts` mediumint(8) unsigned NOT NULL default '0', `todayposts` mediumint(8) unsigned NOT NULL default '0', `lastpost` varchar(110) NOT NULL default '', `allowsmilies` tinyint(1) NOT NULL default '0', `allowhtml` tinyint(1) NOT NULL default '0', `allowbbcode` tinyint(1) NOT 餳T

从mysql 4.1.16->4.0.23导入数据库时出现以下错误

mysql -u mysql_user -pmysql_password sqldb <backup.sql

ERROR 1064 at line 19: 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=big5' at line 10

用以上所说方法，未能找到那些保留字，请教，应如何解决。谢谢

[ 本帖最后由 jingzhongyue_1 于 2006-1-9 16:15 编辑 ]

看了半天好象没有几个弄好的啊

我搬家后全是问号？怎么办？http://jzbbs.be/bbs