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

是否适合 高版本导入低版本呢？

4.1.10-log 怎么向 3.23.51-log 导入啊

我这出大错了

急啊`

原帖由 慕容含情 于 2005-8-1 10:51 发表
晕..
ENGINE = MYISAM DEFAULT CHARSET=latin1
我找不到!!~~

错误说明一字不差，但是我也找不到

谁把这个顶上来了

SQL: CREATE TABLE cdb_sessions ( sid char(6) character set latin1 collate latin1_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', fid smallint(6) unsigned NOT NULL default '0', tid mediumint(8) unsigned NOT NULL default '0', UNIQUE KEY sid (sid)) TYPE=HEAP MAX_ROWS=2000
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 latin1_bin NOT NULL default '', ip1 tinyint(3) unsigne
Errno.: 1064

Similar error report has beed dispatched to administrator before.


出现了这个错误，估计CREATE TABLE cdb_sessions (
  sid char(6) character set latin1 collate latin1_bin NOT NULL default ''
这里要改，可是不知道怎么改，老大能告诉我吗
很急呢

Discuz! info: MySQL Query Error

User: ghostlees
Time: 2005-8-6 8:45pm
Script: /ghostlees/bbs/admincp.php

SQL: REPLACE INTO cdb_attachments VALUES('33401','61185','235219','25284','0','194211.jpg','image/pjpeg','15770','/./86/2/862/forumid_18490/194211_rBGtfz8kAH1O.jpg','1108522943','25','862')
Error: Column count doesn't match value count at row 1
Errno.: 1136

Similar error report has beed dispatched to administrator before.

WHY?

原帖由 冰鸽 于 2005-8-6 18:53 发表
SQL: CREATE TABLE cdb_sessions ( sid char(6) character set latin1 collate latin1_bin NOT NULL default '', ip1 tinyint(3) unsigned NOT NULL default '0', ip2 tinyint(3) unsigned NOT NULL default '0', ...

哪位知道告诉我一声呀

顶上去先

看来这里也没什么人回答
幸好自己解决了，来这快两年第一次问问题

原帖由 冰鸽 于 2005-8-7 16:29 发表
看来这里也没什么人回答
幸好自己解决了，来这快两年第一次问问题

:L:L