好吧,沒用過幾次discuz,后來有點受不了wordpress的卡頓了,所以想轉(zhuǎn)到discuz上,用命令(或phpmyadmin)備份數(shù)據(jù)后,重新安裝discuz,測試下恢復(fù)(導(dǎo)入)數(shù)據(jù)的方法,結(jié)果在填寫相同的表前綴時候.

安裝會報以下錯誤:

當(dāng)前數(shù)據(jù)庫當(dāng)中已經(jīng)含有同樣表前綴的數(shù)據(jù)表,您可以修改“表名前綴”來避免刪除舊的數(shù)據(jù),或者選擇強(qiáng)制安裝,強(qiáng)制安裝會刪除舊數(shù)據(jù),且無法恢復(fù).

蛋疼,在wordpress上重新安裝,表前綴相同會直接覆蓋安裝的,discuz居然不行.

解決辦法:

先和平時一樣安裝discuz,只不過在安裝界面填寫表前綴時候,假設(shè)原來應(yīng)該是pre0_   ,但是因為如果也pre_,就會報錯,所以,我們先隨便填個表前綴 pre9_,然后點擊繼續(xù)安裝.

安裝后,我們在用命令或者phpmyadmin導(dǎo)入我們的備份數(shù)據(jù)到你discuz所使用的數(shù)據(jù)庫中,因為兩個表前綴不一樣,所以導(dǎo)入液不會報錯.

導(dǎo)入備份的數(shù)據(jù)庫后,接著繼續(xù)操作,我們會看到在論壇的config/目錄下,有 config_global.php 和 config_ucenter.php 兩個配置文件,其中config_ucenter.php 是uncenter的配置文件,我這里同時安裝了discuz和 ucenter.

在上面兩個文件中,找到 pre9_ 將其改為  pre0_,然后在訪問我們的論壇,是不是就可以正常訪問,而且數(shù)據(jù)也恢復(fù)(導(dǎo)入)了呢？

最后一步,就是刪除沒用的表前綴 為pr9_ 的表.

附另一種方法,批量刪除指定前綴表,用一下語句:

1. mysql> Select CONCAT( 'drop table ', table_name, ';' ) 
2. -> FROM information_schema.tables 
3. -> Where table_name LIKE 'wp0_%'; 

其中的wp0_就是我們要刪除的表的前綴,大家可以根據(jù)自己的情況修改m顯示的是要我們刪除的所有以wp0_開頭的表m只要按照下面的順序一一輸入就可以刪除了,

1. +-------------------------------------------+ 
2. | CONCAT( 'drop table ', table_name, ';' )  | 
3. +-------------------------------------------+ 
4. | drop table wp0_bannerize;                 | 
5. | drop table wp0_commentmeta;               | 
6. | drop table wp0_comments;                  | 
7. | drop table wp0_gd_manager;                | 
8. | drop table wp0_links;                     | 
9. | drop table wp0_moresecurelogin;           | 
10. | drop table wp0_options;                   | 
11. | drop table wp0_pluginsTalkPLinker;        | 
12. | drop table wp0_pluginsTalkPLinkerOptions; | 
13. | drop table wp0_post_relationships;        | 
14. | drop table wp0_postmeta;                  | 
15. | drop table wp0_posts;                     | 
16. | drop table wp0_postviews_plus;            | 
17. | drop table wp0_sam_ads;                   | 
18. | drop table wp0_sam_blocks;                | 
19. | drop table wp0_sam_errors;                | 
20. | drop table wp0_sam_places;                | 
21. | drop table wp0_sam_zones;                 | 
22. | drop table wp0_term_relationships;        | 
23. | drop table wp0_term_taxonomy;             | 
24. | drop table wp0_terms;                     | 
25. | drop table wp0_usermeta;                  | 
26. | drop table wp0_users;                     | 
27. | drop table wp0_wfBadLeechers;             | 
28. | drop table wp0_wfBlocks;                  | 
29. | drop table wp0_wfBlocksAdv;               | 
30. | drop table wp0_wfConfig;                  | 
31. | drop table wp0_wfCrawlers;                | 
32. | drop table wp0_wfFileMods;                | 
33. | drop table wp0_wfHits;                    | 
34. | drop table wp0_wfHoover;                  | 
35. | drop table wp0_wfIssues;                  | 
36. | drop table wp0_wfLeechers;                | 
37. | drop table wp0_wfLockedOut;               | 
38. | drop table wp0_wfLocs;                    | 
39. | drop table wp0_wfLogins;                  | 
40. | drop table wp0_wfNet404s;                 | 
41. | drop table wp0_wfReverseCache;            | 
42. | drop table wp0_wfScanners;                | 
43. | drop table wp0_wfStatus;                  | 
44. | drop table wp0_wfThrottleLog;             | 
45. | drop table wp0_wfVulnScanners;            | 
46. | drop table wp0_wp_bot_counter;            | 
47. | drop table wp0_wp_rp_tags;                | 
48. | drop table wp0_yarpp_related_cache;       | 
49. +-------------------------------------------+ 
50. //開源軟件:Vevb.com 
51. 45 rows in set (0.02 sec)