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

dui对呀


你，怎么    不回答？

SQL 查询:

--
-- Dumping data for table `cdb_searchindex`
--
-- --------------------------------------------------------
--
-- Table structure for table `cdb_sessions`
--
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 =1000


???哪错了啊！

没人来帮忙下啊？

原帖由 leaftea 于 2005-10-11 13:50 发表
SQL 查询:

--
-- Dumping data for table `cdb_searchindex`
--
-- --------------------------------------------------------
--
-- Table structure for table `cdb_sessions`
--
CREATE TABLE ...

1. DROP TABLE IF EXISTS cdb_sessions;
   
2. CREATE TABLE cdb_sessions (
   
3.   sid char(6) binary NOT NULL default '',
   
4.   ip1 tinyint(3) unsigned NOT NULL default '0',
   
5.   ip2 tinyint(3) unsigned NOT NULL default '0',
   
6.   ip3 tinyint(3) unsigned NOT NULL default '0',
   
7.   ip4 tinyint(3) unsigned NOT NULL default '0',
   
8.   uid mediumint(8) unsigned NOT NULL default '0',
   
9.   username char(15) NOT NULL default '',
   
10.   groupid smallint(6) unsigned NOT NULL default '0',
    
11.   styleid smallint(6) unsigned NOT NULL default '0',
    
12.   invisible tinyint(1) NOT NULL default '0',
    
13.   action tinyint(1) unsigned NOT NULL default '0',
    
14.   lastactivity int(10) unsigned NOT NULL default '0',
    
15.   fid smallint(6) unsigned NOT NULL default '0',
    
16.   tid mediumint(8) unsigned NOT NULL default '0',
    
17.   UNIQUE KEY sid (sid)
    
18. ) TYPE=HEAP MAX_ROWS=1000;

复制代码

导入了，还是乱码。

另外没找到ENGINE = HEAP DEFAULT CHARSET=latin1这一句。

[ 本帖最后由 strawbarry 于 2005-10-25 19:06 编辑 ]

乱码应该是编码的问题，mysql 4.0/4.1好象默认都是latin1？到MySQL5.0可以选择 utf8 gbk 等编码
这个东西还不太明白

扯淡

我的也出现Time: 2005-11-7 1:05pm
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', PRIMARY KEY (uid,fid)) ENGINE=InnoDB DEFAULT CHARSET=latin1
Error: You have an error in your SQL syntax near 'ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.
这个问题~``按照楼主说拉~`没用~`还是找不到楼主说的那些语句~~

做个说明：

1. ENGINE = HEAP DEFAULT CHARSET=latin1  

复制代码

这句许多人都找不到，试试这样  改这句：

1. 
   
2. ENGINE=HEAP DEFAULT CHARSET=latin1

复制代码

以及

1. ENGINE = MYISAM DEFAULT CHARSET=latin1

复制代码

改为：

1. ENGINE=MYISAM DEFAULT CHARSET=latin1

复制代码

[ 本帖最后由 leidm331 于 2005-11-8 21:17 编辑 ]

头大!
今天本来换空间的,可惜导不了,哎~~只得作罢.
不知道3.0是不是还有这个问题!