關於從mysql4.0伺服器轉換至5.0伺服器

關於從mysql4.0伺服器轉換至5.0伺服器

小弟的論壇數據十分麻煩,論壇版本是6.0的
而且很奇妙地容量十分巨大,不但不能從mysql4.0伺服器轉換至5.0伺服器,而且就連同版本資料庫也轉換不到

疑問一,
恢復到某備份時顯示錯誤

1. Discuz! info: MySQL Query Error
   
2. 
   
3. User: admin
   
4. Time: 2007-11-30 11:09pm
   
5. Script: /xxx/admincp.php
   
6. 
   
7. 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=big5 AUTO_INCREMENT=354
   
8. 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
   
9. Errno.: 1064

复制代码

疑問二:

又出現了以下錯誤

1. Discuz! info: MySQL Query Error
   
2. 
   
3. Time: 2007-12-1 5:39am
   
4. Script: /xxx/tools.php
   
5. 
   
6. SQL: INSERT INTO [Table]members VALUES ('21020',0x6b6f79,0x6531306164633339343962613539616262653536653035376632306638383365,'',0x3263633762303566,'0','0','10','0','',0x3231382e3130322e3231362e313037,'1168608902',0x3231382e3130322e3231362e313037,'1168608902','1168608902','0','0','0','0','0','0','0','1420','0','0','0','0','0','0',0x686f6b696e77616932303030407961686f6f2e636f6d2e686b,'0000-00-00','1','0','0','0','0','0','1','1','1','0',0x39393939,'1','0','','0','0','','','0','2','26','0','0','','0','0','0','0','0','0','0','0','1','0','9','18','18','8','8','1','1','1','1',0xb8f4a448,'',0xa46aae61a74face5a7daaafc7e7e,'0','','0','0','')
   
7. Error: Duplicate entry 'koy' for key 2
   
8. Errno.: 1062

复制代码

應如何解決,求高手解答

[ 本帖最后由 starking716 于 2007-12-1 13:41 编辑 ]

导入数据缺少表 cdb_medals 勋章数据表缺损，简易重新备份后再次导入，至于MYSQL4.0-》5.0，后台备份时选择更多选项，选择MYSQL5.0即可，简易再次备份前后台优化下数据库，并用数据库效验工具检查下数据表结构是否正确

請問可否詳細解釋一下如何簡易重新備份後再次導入-.-
抱歉

疑問二:

又出現了以下錯誤

1. Discuz! info: MySQL Query Error
   
2. 
   
3. Time: 2007-12-1 5:39am
   
4. Script: /xxx/tools.php
   
5. 
   
6. SQL: INSERT INTO [Table]members VALUES ('21020',0x6b6f79,0x6531306164633339343962613539616262653536653035376632306638383365,'',0x3263633762303566,'0','0','10','0','',0x3231382e3130322e3231362e313037,'1168608902',0x3231382e3130322e3231362e313037,'1168608902','1168608902','0','0','0','0','0','0','0','1420','0','0','0','0','0','0',0x686f6b696e77616932303030407961686f6f2e636f6d2e686b,'0000-00-00','1','0','0','0','0','0','1','1','1','0',0x39393939,'1','0','','0','0','','','0','2','26','0','0','','0','0','0','0','0','0','0','0','1','0','9','18','18','8','8','1','1','1','1',0xb8f4a448,'',0xa46aae61a74face5a7daaafc7e7e,'0','','0','0','')
   
7. Error: Duplicate entry 'koy' for key 2
   
8. Errno.: 1062

复制代码

[ 本帖最后由 starking716 于 2007-12-1 13:41 编辑 ]

打开这卷备份，把叫koy的这条记录删掉。保存后再恢复。

我發覺很多用戶都有~這個符號,可不可以一次性全刪去?

我嘗試過忽略cdb_medal這個數據表不備份,結果在成功回復後顯示

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stargame/domains/xxxx.org/public_html/include/db_mysql.class.php on line 54

Discuz! info: MySQL Query Error

User: xxx
Time: 2007-12-1 6:38pm
Script: /xxx/index.php

SQL: SELECT medalid, name, image FROM [Table]medals WHERE available='1'
Error: Table xxx.[Table]medals' doesn't exist
数据表缺失,请恢复备份数据

DROP TABLE IF EXISTS cdb_medals;
CREATE TABLE cdb_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 '',
  PRIMARY KEY (medalid)
) TYPE=MyISAM AUTO_INCREMENT=11;

INSERT INTO cdb_medals VALUES ('1','Medal No.1','0','medal1.gif');
INSERT INTO cdb_medals VALUES ('2','Medal No.2','0','medal2.gif');
INSERT INTO cdb_medals VALUES ('3','Medal No.3','0','medal3.gif');
INSERT INTO cdb_medals VALUES ('4','Medal No.4','0','medal4.gif');
INSERT INTO cdb_medals VALUES ('5','Medal No.5','0','medal5.gif');
INSERT INTO cdb_medals VALUES ('6','Medal No.6','0','medal6.gif');
INSERT INTO cdb_medals VALUES ('7','Medal No.7','0','medal7.gif');
INSERT INTO cdb_medals VALUES ('8','Medal No.8','0','medal8.gif');
INSERT INTO cdb_medals VALUES ('9','Medal No.9','0','medal9.gif');
INSERT INTO cdb_medals VALUES ('10','Medal No.10','0','medal10.gif');

原帖由 starking716 于 2007-12-1 13:19 发表
請問可否詳細解釋一下如何簡易重新備份後再次導入-.-
抱歉

疑問二:

又出現了以下錯誤Discuz! info: MySQL Query Error

Time: 2007-12-1 5:39am
Script: /xxx/tools.php

SQL: INSERT INTO members VALU ...

建议，不是建议，打错了~~