1
wishcraft
Newbb 3.0 to Xforum 4.x or 5.x

I have had a few emails about how to upgrade from newbb to X-Forum. The following SQL you can fire you will need to replace prefix_ with your database prefix but this will copy all the data from newbb to xforum and allow it to be used.

TRUNCATE prefix__xf_archive;
TRUNCATE prefix__xf_attachments;
TRUNCATE prefix__xf_categories;
TRUNCATE prefix__xf_digest;
TRUNCATE prefix__xf_extras;
TRUNCATE prefix__xf_field;
TRUNCATE prefix__xf_forums;
TRUNCATE prefix__xf_moderates;
TRUNCATE prefix__xf_online;
TRUNCATE prefix__xf_posts;
TRUNCATE prefix__xf_posts_text;
TRUNCATE prefix__xf_reads_forum;
TRUNCATE prefix__xf_reads_topic;
TRUNCATE prefix__xf_report;
TRUNCATE prefix__xf_topics;
TRUNCATE prefix__xf_visibility;
TRUNCATE prefix__xf_votedata;
INSERT INTO prefix__xf_archive SELECT FROM prefix__bb_archive;
INSERT INTO prefix__xf_attachments SELECT FROM prefix__bb_attachments;
INSERT INTO prefix__xf_categories SELECT FROM prefix__bb_categories;
INSERT INTO prefix__xf_digest SELECT FROM prefix__bb_digest;
INSERT INTO prefix__xf_forums SELECT FROM prefix__bb_forums;
INSERT INTO prefix__xf_moderates SELECT FROM prefix__bb_moderates;
INSERT INTO prefix__xf_online SELECT FROM prefix__bb_online;
INSERT INTO prefix__xf_posts (post_idpidtopic_idforum_idpost_timeuidposter_nameposter_ip, `subject`, dohtmldosmileydoxcodedobrdoimageiconattachsig,approved,post_karma,attachment,require_replySELECT FROM prefix__bb_posts;
INSERT INTO prefix__xf_posts_text SELECT FROM prefix__bb_posts_text;
INSERT INTO prefix__xf_reads_forum SELECT FROM prefix__bb_reads_forum;
INSERT INTO prefix__xf_reads_topic SELECT FROM prefix__bb_reads_topic;
INSERT INTO prefix__xf_report SELECT FROM prefix__bb_report;
INSERT INTO prefix__xf_topics SELECT FROM prefix__bb_topics;
INSERT INTO prefix__xf_votedata SELECT FROM prefix__bb_votedata;


You will be able to fire this in phpmyadmin or SQL tools like sqlYog from webYog.
Resized Image
http://www.ohloh.net/accounts/226400

Follow, Like & Read:-

twitter.com/RegaltyFamily
github.com/Chronolabs-Cooperative
facebook.com/DrAntonyRoberts

Login

Who's Online

329 user(s) are online (272 user(s) are browsing Support Forums)


Members: 0


Guests: 329


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits