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

ENGINE = HEAP DEFAULT CHARSET=latin1
找不到

ENGINE = HEAP DEFAULT CHARSET=latin1
找不到

頂上去!

ENGINE = HEAP DEFAULT CHARSET=latin1
找不到

来个人说话啊

出现这个,特郁闷
Warning: mb_strpos(): Unknown encoding or conversion error

There seems to have been a problem with the database of your Discuz!
Board

Discuz! info: MySQL Query Error

User: sweet_candy1101
Time: 2006-6-8 7:54am
Script: /post.php

SQL: UPDATE cdb_forums SET threads=threads-1, posts=posts-1,
lastpost='856        hips don't  lie - shalira ft wyclef jean        1149727795       
sweet_candy1101' WHERE fid='43'
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
't  lie - shalira ft wyclef jean        1149727795        sweet_candy1101' WHERE
fid='43'' at line 1
Errno.:  1064

Please check-up your MySQL server and forum scripts, similar errors
will not be reported again in recent 24 hours
If you have troubles in solving this problem, please visit Discuz!
Community http://www.Discuz.net.

顶起来

谢谢楼主

ENGINE = HEAP DEFAULT CHARSET=latin1
找不到

来个人说话啊

对于使用GBK版本的，
用下面的办法试一下。

ALTER TABLE `cdb_sessions`
TYPE = MyISAM
CHARACTER SET gbk

ALTER TABLE `cdb_sessions`
CHANGE `sid` `sid` CHAR( 6 )
CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL