Web Hosting Talk







View Full Version : How can I import posts from one phpbb to an other?


Postmaster
01-14-2005, 07:25 PM
Is there anyway I can import my posts or maybe a few from one of my phpbb to my other one? How do I do this?

Tyler
01-14-2005, 07:47 PM
Through MySQL. But good luck!

Vlada
01-14-2005, 07:48 PM
No can do I think...you can only import the whole mysql base.

Or maybe you can but you have to know exectly what to import from mysql.

Marble
01-14-2005, 09:01 PM
you'd have to think hard about what part of phpBB 1 you'd want to copy to phpBB2 as you would soon realise the whole db structure is acting as an entity. Why do you need to copy over certain data only versus the whole db?

Postmaster
01-14-2005, 09:17 PM
well, I have one of my phpbb forums intergarted with my dating script so the data base has different users of those of the dating site, however I've decided to close my other forum and I want all my old post epscially the ones indexed by google. Its an impossible task?

Tyler
01-14-2005, 09:30 PM
You can make it so no one can post; and say it's closed, but SE still come's along and index them. But what you are thinking about can take serveal hours.

Marble
01-15-2005, 12:12 AM
It would be a tedious task. Basically picture user A in phpBB 1 with id 1 will not be the same as user A in phpBB 2 with id 1... make sense?

So you would probably have to gather users from phpBB board 1, change there id #'s to start AFTER the users in phpBB board 2. Now methodically change each user id on each table to match accordingly, renumber the forum post id's to start AFTER the second forums id #'s so that in essence you are APPENDING the data from phpBB board 1 to the end of phpBB board 2... Times that by the number of tables you have... But what you will find is table references will be made between each other, so maybe forum post id 23 you will find that the id # is used in many different places... so it will take some strategy, but it is possible.

One thing I would do before actually doing it, is backup both boards, then freeze the boards so no one can post, maybe even temporarily disabling both boards... you don't want anything to change while you are doing this...

Postmaster
01-15-2005, 05:47 PM
I hardly know html, let a long mess around with data bases lol..