• Welcome to Simple Machines Community Forum. Please login or sign up.
November 28, 2021, 04:02:25 PM

News:

SMF 2.1 RC4 has been released! Try it out and help us test! :) Read more.


Migrating topics to a new install

Started by fatesjoke03, November 18, 2009, 03:54:02 PM

Previous topic - Next topic

fatesjoke03

Okay, not as simple a question as it may seem. Here is the deal.

I did a clean install of SMF 2.0 RC2 on another part of my site. I wanted a clean slate design wise and planned on moving topics over later. During the design portion I created a slew of new boards and child boards and though to myself that I would take this opportunity to create a more dynamic forum.

Well, job well done and people are loving it but I now have no way to get the 10,000 posts from my old forum over to the new one. Board ID's are totally different and some categories do not even exist anymore.

I do not want to copy and paste them all because I was able to import the member list and I do not want to claim credit for their posts. I realize I can copy and paste and then edit the DB to give the original poster credit but well, 10,000 posts would be a LONG time spent editing my DB.

Am I SOL on this or is there a trick I am missing?

tyty1234

What you could've done is a clean install of RC2, and if the database structure is the same (meaning you are importing a database from an old version of SMF 2.0) then just import all the important stuff (attachments, boards, messages, topics, members, etc) and everything should've clicked in place. Then running upgrade.php to make sure everything was upgraded properly. Then you would go ahead and add the new boards in and delete/create necessary categories afterwards.

However, you did almost the complete opposite, so not sure what you could do without destroying your databse, and without spending so much time.

If you think I'm getting the wrong idea, can you please explain yourself a bit more so that I can fully understand? Thanks. :)
My Activity: Inactive
My Links: tyty1234's SMF Site | SMF Package Parser | SMF Helper | My Mods [5]
Subscribe to my SMF blog for updates
PMs for support will not be accepted, unless requested otherwise.

fatesjoke03

No, you pretty much got it. I know I did things in the wrong order, looks like I will be doing a lot of database editing after a lot of copy and pasting.

hadesflames

November 21, 2009, 03:33:37 PM #3 Last Edit: November 21, 2009, 03:58:11 PM by hadesflames
you could try deleting your current boards, then importing the old boards. Then you can import the topics and finally make the changes to the boards you had made via the admin panel. Seems a lot better than MANUALLY adding all of the posts...

tyty1234

Quote from: fatesjoke03 on November 21, 2009, 03:32:03 PM
No, you pretty much got it. I know I did things in the wrong order, looks like I will be doing a lot of database editing after a lot of copy and pasting.
Well, don't copy and paste, but rather export and import. That would be a way faster task.
My Activity: Inactive
My Links: tyty1234's SMF Site | SMF Package Parser | SMF Helper | My Mods [5]
Subscribe to my SMF blog for updates
PMs for support will not be accepted, unless requested otherwise.

fatesjoke03

Hmmmm, explain that one to me please. Database wise? Is there a way to import/export topics without the board info?

tyty1234

No there is no way to do that. Have you tried what hadesflames suggested?

Quote from: hadesflames on November 21, 2009, 03:33:37 PM
you could try deleting your current boards, then importing the old boards. Then you can import the topics and finally make the changes to the boards you had made via the admin panel. Seems a lot better than MANUALLY adding all of the posts...
My Activity: Inactive
My Links: tyty1234's SMF Site | SMF Package Parser | SMF Helper | My Mods [5]
Subscribe to my SMF blog for updates
PMs for support will not be accepted, unless requested otherwise.

fatesjoke03

Too late for that unfortunately, new posts on the new boards already.....

No worries, if it cannot be done it cannot be done. Hopefully someone learns from my lack of planning.

Advertisement: