just heard about the wonderful miniBB...so 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.

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

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?

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.

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 work..eh?

jmahon
I dont think its just as simple as renaming the table in the database

You think wrong :)

sherwin
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.

hmm...there you have it ladies and gents...proved wrong, once again ;)

I wanna get off that slow POS! =)

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

btw, thank you

50$.

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 =
minibb_users.user_id;

# 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 =
tmp_post_count.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 =
minibb_users.user_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 =
PHPBB.phpbb_post_text.post_id;

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!

Depending on the db structure change, it should be pretty trivial to fix (?)

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.

ok, that looks easy enough to adapt.