miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
Master Class miniBB Support Forums / Master Class /   

Conversion: phpbb -> minibb

Page  Page 1 of 3:  1  2  3  Next »  
Author sherwin
#1 | Posted: 8 Apr 2003 01:12 
just heard about the wonderful far so good on what i read from the index page...

quick question... i am using phpBB, but am willing to try miniBB ... is it easy to get my data in the mysql dbs that were made by phpBB? if so, how...?

just wondering, if this isn't a feature yet... it might be a good thing to have in terms of other bb's as well =)

please let me know on anyone's earliest convenience.

thanks advance.

Author jmahon
#2 | Posted: 8 Apr 2003 01:49 
this board is the best ever. I've tryed phpbb, ikonboard(both cgi and php versions), xmb, postnuke module, and a number of other not so popular names but this is by far the best.

use this

Author sherwin
#3 | Posted: 8 Apr 2003 01:54 | Edited by: sherwin 
okay...i know i want to use it... but that wasn't the kind of answer i was looking for =)

how easily/quickly can i transfer/migrate my date from phpBB >> miniBB?

Author 4days
#4 | Posted: 8 Apr 2003 03:00 
it depends if users on your phpbb board use private messaging or voting much, minibb doesn't support either without an add-on/hack.

beyond that, it's a case of building a user list and exporting phpbb_forums/phpbb_posts and any other bits and bobs you think will be handy in populating the new board.

Author jmahon
#5 | Posted: 8 Apr 2003 03:02 
but, phpbb might and im sure it does use a different kind of posting method, I dont think its just as simple as renaming the table in the database...that might be hard

Author Team
#6 | Posted: 8 Apr 2003 10:26 
I dont think its just as simple as renaming the table in the database

You think wrong :)

It guess, database could be converted (Sergei from our team did the convertion for vBulletin), but of course it is much different as miniBB's. It depends actually on many factors: which version of phpBB you have, how phpBB translates the BB-codes, how it stores users etc etc. Actually, we haven't wrote migration converters only for one reason: phpBB and another boards are changing their structure with practically each version. We have a lot of another work to do instead of watching their processes.

Author jmahon
#7 | Posted: 8 Apr 2003 14:15 
hmm...there you have it ladies and gents...proved wrong, once again ;)

Author Anonymous
#8 | Posted: 31 May 2004 06:31 
I wanna get off that slow POS! =)

There are NO free importing scripts.... how much would u charge to code one for me?

Author Anonymous
#9 | Posted: 31 May 2004 06:32 
btw, thank you

Author Team
#10 | Posted: 31 May 2004 09:38 

Author mohrt
#11 | Posted: 28 Apr 2005 19:41 | Edited by: mohrt 
My contribution, a script to convert phpbb users, forums, topics and posts to minibb. This script assumes your phpbb database name is PHPBB, your minibb table names are prefixed with minibb_* and the phpbb tables have phpbb_* prefix. Adjust where necessary. You will have to clear the minibb_users table if you run this script more than once.

# phpBB 2.0 to miniBB 2.0 Converter
# Copyright (C) 2005 Monte Ohrt
# Purpose:
# The script will transfer categories, forums, users, and posts
# from phpBB 2.0 to miniBB 2.0.
# Prerequisites:
# - phpBB 2.0 and miniBB 2.0 dbs are installed on the same server
# - miniBB 2.0 is empty, fresh install
# - phpBB 2.0 tables are prefixed with "phpbb_"
# - miniBB 2.0 tables are prefixed with "minibb_"
# Directions:
# mysql minibb < phpbb2minibb.sql

# Clear out minibb tables

TRUNCATE TABLE minibb_forums;
TRUNCATE TABLE minibb_posts;
TRUNCATE TABLE minibb_topics;

# No categories in miniBB, skip.

# Copy forums.

INSERT INTO minibb_forums (forum_id, forum_name, forum_desc, forum_order, forum_icon, topics_count, posts_count)
SELECT forum_id, forum_name, forum_desc, forum_order, 'default.gif', forum_topics, forum_posts
FROM PHPBB.phpbb_forums;

# Copy users.

INSERT INTO minibb_users (user_id, username, user_regdate, user_password,
user_email, user_icq, user_website, user_occ, user_from, user_interest,
user_viewemail, user_sorttopics, user_newpwdkey, user_newpasswd, language, activity)
SELECT user_id, username, FROM_UNIXTIME(user_regdate), user_password, user_email, user_icq,
user_website, user_occ, '', user_interests, user_viewemail, 1, '', '', user_lang, 1
FROM PHPBB.phpbb_users;

# No security access in minibb, skip.

# Copy topics.

INSERT INTO minibb_topics (topic_id, topic_title, topic_poster,
topic_poster_name, topic_time, topic_views, forum_id, topic_status,
topic_last_post_id, posts_count, sticky)
SELECT DISTINCT topic_id, topic_title, topic_poster,
'', FROM_UNIXTIME(topic_time), topic_views, forum_id, topic_status, topic_last_post_id,0,0
FROM PHPBB.phpbb_topics;

# get poster name
update minibb_topics, minibb_users set minibb_topics.topic_poster_name =
minibb_users.username where minibb_topics.topic_poster =

# calculate post count for each topic

create table tmp_post_count (topic_id int, post_count int);
insert into tmp_post_count select p.topic_id, count(p.post_id) from PHPBB.phpbb_posts p group by p.topic_id;

update minibb_topics, tmp_post_count set minibb_topics.posts_count =
tmp_post_count.post_count where minibb_topics.topic_id =

drop table tmp_post_count;

# Copy posts.

INSERT INTO minibb_posts (post_id, forum_id, topic_id, poster_id, poster_name,
post_text, post_time, poster_ip, post_status)
SELECT DISTINCT p.post_id, p.forum_id, p.topic_id, p.poster_id, '',
'', FROM_UNIXTIME(p.post_time), poster_ip, 0
FROM PHPBB.phpbb_posts p;

# get poster name
update minibb_posts, minibb_users set minibb_posts.poster_name =
minibb_users.username where minibb_posts.poster_id =

# Copy post text.

update minibb_posts, PHPBB.phpbb_posts_text set minibb_posts.post_text =
PHPBB.phpbb_posts_text.post_text where minibb_posts.post_id =

Author Team
#12 | Posted: 28 Apr 2005 20:15 
Ooopps.... such a cool script - and we are going to change database structure in the next RC3 version! :-( Could you fix your script after that? I hope, this change will be the last on database structure...

Thank you!

Author mohrt
#13 | Posted: 28 Apr 2005 21:13 
Depending on the db structure change, it should be pretty trivial to fix (?)

Author Team
#14 | Posted: 28 Apr 2005 21:40 
We just have no time to work on it nowadays ourselves... there will be some new fields in database, which I am sure are in phpBB too - topic_last_post_time it topics, forum_group in forums and and num_topics + num_posts in user's profile.

Author mohrt
#15 | Posted: 28 Apr 2005 21:44 
ok, that looks easy enough to adapt.

Page  Page 1 of 3:  1  2  3  Next » 
Master Class miniBB Support Forums / Master Class / Conversion: phpbb -> minibb Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

You are welcome to post anonymously, by entering a nickname with no password (if the similar Username has not been taken yet), or by leaving both fields empty. If you have a forums account, you can also sign in from this page without posting a message, or sign in and post at once.

Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Get the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB