http://forum.snitz.com/forum/default.asp
一個是竹貓大大發表的phpbb20rc2版
那我想要將兩個資料庫中的文章合併..
所以剛剛找了一些檔案
有找到這個...
http://www.mraluca.go.ro/snitz2phpbb2convertor.zip
說明檔如下：
代碼: 選擇全部
Snitz v3.1 -> phpBB2 rc1
-----------------------
Requirements:
- Snitz 3.1 MySQL database
- phpBB2 rc1 MySQL database
- 15 free minutes
How to import
-------------
Step 1:
First you have to do a clean installation of phpBB2 rc1, because my scripts will alter only some of the tables (phpbb_categories, phpbb_forums, phpbb_users, phpbb_groups, phpbb_user_group, phpbb_posts, phpbb_posts_text and phpbb_topics);
Step 2:
Empty these tables:
-phpbb_categories
-phpbb_forums
-phpbb_groups
-phpbb_user_group
-phpbb_posts
-phpbb_posts_text
-phpbb_topics
Don't delete them, only empty :).
Delete from phpbb_users all entries EXCEPT the first one (anonymous user).
(yes, I can empty these tables myself but maybe somebody will not read these instructions before running scripts)
Step 3:
Now you have to make proper changes in config.php file (database name, username, password, table's names).
Step 4:
Run:
-members.php
-categories.php
-forums.php
-topics.php (RUN THIS BEFORE RUNNING posts.php)
-posts.php
Step 5:
Somebody must be administrator :) so you have to change the 'user_level' field from 'phpbb_users' table. Default value is 0. Change it into 1 and that user will be administrator.
Step 6:
Actually, that's all!
Notes
-----
If you want to convert from an Access database (.mdb) you can use MySQL ODBC driver to convert it into a MySQL database.
Contact
-------
You can send me bugs or questions at ralucam@rol.ro or ralucam@mail.com.
Raluca Musaloiu-E.
12 february 2002
那我先將自己的想法說出..
就是先另外裝一個phpbbrc1
用他的程式..轉資料庫..
如果可跑..
在將rc1升級成rc2 後 直接用mysql指令將rc1跟我舊的rc2合併\r
這樣是否可行 :-o ？....因為心理毛毛的 :oops:
