Uploading converted topics/posts to the forum database

[fantanoice]

Yes, n00bs question for moving forums.

I basically have some topics/posts converted from Forumer to SMF (using a bot to do so). I now need to know how to upload it to the database, which I'm rather clueless about.

I'm using CPanel X, if that helps.

Cheers to anybody who can give me some assistance. 🙂

 

[Nathan]

Note: I charge $10 per hour for the information your about to read so please PM me for my paypal. Just kidding.

Step 1 - Make your new DB, user and assign your user to the DB with all permissions, to do this:

Databases - MySQL Databases - Create New Database - New Database: (chuck in whatever name you'd like) - Create Database.

MySQL Users - Add New User - Username: (chuck in whatever name you'd like) - Password: (chuck in whatever password you'd like or you can use the 'generate password tool' to generate a very secure password) - Password (Again): (same as above) - Create User.

Add User To Database - User: (select the user you just created from the drop down box) - Database: (select the DB you just created from the drop down box) - Add - MySQL Account Maintenance - Manage User Privileges - Hit the checkbox next to "ALL PRIVILEGES" - Make Changes.

Step 2 - Go back home now go to:

Databases - phpMyAdmin - Select the DB you made earlier (in step 1) on the left hand side - Up the top hit Import - File to import - Location of the text file (using the browse button, browse to your backed up DB on your PC) - Leave all the other options as is and hit Go.

Step 2 - You'll now need to update your SMF configuration details. Im not too sure what file is SMF's config file as ive never really used it before, however it should be something like "config.php". You'll just need to change the DB name to the full one created earlier including your account extension before it, your password and your user.

Presto!

 

[fantanoice]

Note: I charge $10 per hour for the information your about to read so please PM me for my paypal. Just kidding.

Lol, I was going to say...

Anyway, cheers for that Nathan. I'll give it a go tomorrow as I'm heading to bed now. +Rep.

 

[Nathan]

Thanks for the rep, good luck 😀

I felt like a joke 🙂

 

[fantanoice]

Okay, I finally got around to doing this. I'm receiving an error, so perhaps somebody here might know how to fix it?

This occurred when I tried to import the categories_forums_smf.sql file.

Error

SQL query:

TRUNCATE TABLE `ipb_boards` ;

MySQL said: Documentation
#1146 - Table 'dashingw_PostDB.ipb_boards' doesn't exist

Thanks to anybody who might help. 😉

 

[Zenrer]

Can you link us to the SQL file?

 

[fantanoice]

Could you please ask that in English?

If you mean the converted file, it's on my computer and I'm trying to upload it... 😵

 

[Zenrer]

The file you are importing, can you link me to it?

 

[fantanoice]

No because it is on my hard drive.

 

[Zenrer]

Can you post it in the

 tags or give me a link to download it was what I meant xD

 

[fantanoice]

Okay, I opened it in a text editor so this should be the code:

TRUNCATE TABLE `ipb_boards`; TRUNCATE TABLE `ipb_categories`;
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (2, 255, 0, 0, 2, 'Nothing in Particular', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (3, 255, 0, 0, 3, 'Dashing HQ', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (4, 255, 0, 0, 4, 'Game Domain', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (5, 255, 0, 0, 5, 'MK Central', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (8, 255, 0, 0, 8, 'Recreation Whilst Racing', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (11, 255, 0, 0, 11, 'Old News and Archives', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (15, 255, 0, 0, 15, 'Can o' Spam - Home of the Vodka Fanta', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (18, 255, 0, 0, 18, 'Entertaining Stuff', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (27, 255, 0, 0, 27, 'Newbie Realm', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (28, 255, 0, 0, 28, 'Toad Town Bulletin', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (31, 255, 0, 0, 31, 'Graphics', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (34, 255, 0, 0, 34, 'Advertisments', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (36, 255, 0, 0, 36, 'Others', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (42, 255, 0, 0, 42, 'Karter Discussions', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (44, 255, 0, 0, 44, 'Ideas and Feedback', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (45, 255, 0, 0, 45, 'Serious Conversations', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (46, 255, 0, 0, 46, 'Fun Net Stuff', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (52, 255, 0, 0, 52, 'Fanfic', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (53, 255, 0, 0, 53, 'Fanart', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (59, 255, 0, 0, 59, 'Retro Mario Kart', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (60, 255, 0, 0, 60, 'Hip Mario Kart', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (62, 255, 0, 0, 62, 'Fanta Zone', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (63, 255, 0, 0, 63, 'Dashing Competitions', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (64, 255, 0, 0, 64, 'Fanatics', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (65, 255, 0, 0, 65, 'Entertainment', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (67, 255, 0, 0, 67, 'DASHING HAS MOVED', '');
INSERT INTO `ipb_boards` (ID_BOARD, ID_CAT, childLevel, ID_PARENT, boardOrder, name, description) VALUES (68, 255, 0, 0, 68, 'New Forum', '');
INSERT INTO `ipb_categories` (ID_CAT, catOrder, name) VALUES (255, 254, 'Lost category');

 

[John1]

Well the reason for the error is because your tables are for IPB not SMF, so when you try to call the IPB table on your site, it gives the error.

MySQL said: Documentation
#1146 - Table 'dashingw_PostDB.ipb_boards' doesn't exist

dashingw_PostDB.ipb_boards - that field is not in your database!

 

[fantanoice]

So... how do I fix that?