搬家出现问题！！

搬家出现问题！！
最近要换空间，我原来的 MySQL 版本 4.0.21-nt

要换过去的 MySQL 版本 5.0.27-community-nt

补充一点：我导出的时候选择了5.X以上的版本。

我成功导出了，但是导入到新空间里的却不行。提示以下



Discuz! info: MySQL Query Error

User: admin
Time: 2007-10-4 2:40pm
Script: /bbs/admincp.php

SQL: CREATE TABLE [Table]medals ( medalid smallint(6) unsigned NOT NULL auto_increment, name varchar(50) NOT NULL default '', available tinyint(1) NOT NULL default '0', image varchar(30) NOT NULL default '', use tinyint(1) NOT NULL default '0', rest mediumint(8) NOT NULL default '0', lastuser varchar(32) default '', s1 mediumint(8) NOT NULL default '0', r1 mediumint(8) NOT NULL default '0', s2 mediumint(8) NOT NULL default '0', r2 mediumint(8) NOT NULL default '0', s3 mediumint(8) NOT NULL default '0', r3 mediumint(8) NOT NULL default '0', s4 mediumint(8) NOT NULL default '0', r4 mediumint(8) NOT NULL default '0', s5 mediumint(8) NOT NULL default '0', r5 mediumint(8) NOT NULL default '0', s6 mediumint(8) NOT NULL default '0', r6 mediumint(8) NOT NULL default '0', s7 mediumint(8) NOT NULL default '0', r7 mediumint(8) NOT NULL default '0', s8 mediumint(8) NOT NULL default '0', r8 mediumint(8) NOT NULL default '0', post mediumint(8) NOT NULL default '0', credit mediumint(8) NOT NULL default '0', regday mediumint(8) NOT NULL default '0', digest mediumint(8) NOT NULL default '0', pageview mediumint(8) NOT NULL default '0', online mediumint(8) NOT NULL default '0', admin mediumint(8) NOT NULL default '0', thread mediumint(8) NOT NULL default '0', reply mediumint(8) NOT NULL default '0', PRIMARY KEY (medalid)) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=11
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 'use tinyint(1) NOT NULL default '0', rest mediumint(8) NOT NULL default '0', l' at line 1
Errno.: 1064

无法导入。。。。
这个应该是空间商的问题
尽量联系空间商吧。。。

[ 本帖最后由 likethis 于 2007-10-4 15:30 编辑 ]

在phpmyadmin或者数据库升级里执行这个

alter table cdb_medals drop column 'use';


然后再备份。

不能用




升级错误，MySQL 提示: 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 ''use'' at line 1 ，请返回。


[ 点击这里返回上一页 ]

Discuz! info: MySQL Query Error

User: admin
Time: 2007-10-4 8:03pm
Script: /discuz/admincp.php

SQL: CREATE TABLE [Table]payset ( groupid int(5) unsigned NOT NULL default '0', type tinyint(1) NOT NULL default '1', enable tinyint(1) NOT NULL default '0', allowrank tinyint(1) NOT NULL default '0', allowcheck tinyint(1) NOT NULL default '0', allowview tinyint(1) NOT NULL default '0', allowforum tinyint(1) NOT NULL default '0', forum varchar(255) NOT NULL default '0,0,0,0,0,0,0,0', leaveday mediumint(8) NOT NULL default '0', group mediumint(8) NOT NULL default '0', getprice mediumint(8) NOT NULL default '0', tax mediumint(8) NOT NULL default '0', up mediumint(8) NOT NULL default '0', down mediumint(8) NOT NULL default '0', rank varchar(255) NOT NULL default '0,0,0,0,0', check varchar(255) NOT NULL default '0,0,0,0,0', well varchar(255) NOT NULL default '0,0,0,0,0', top varchar(255) NOT NULL default '0,0,0,0,0', admin varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', post varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', digest varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', online varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', pageview varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', KEY groupid (groupid)) 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 'group mediumint(8) NOT NULL default '0', getprice mediumint(8) NOT NULL default' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.