Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Malgol on April 30, 2012, 04:28:37 PM

Title: Moving part of the database to another forum!
Post by: Malgol on April 30, 2012, 04:28:37 PM
Hi,
I've created a new forum and would like to transfer the member database and one of the Categories to the new one.
Is this possible in a some what simple way?

What happens if a extract the part from the database that contain topics and members and then just add them to the new one with phpmyadmin?

// Malgol
Title: Re: Moving part of the database to another forum!
Post by: Colin on April 30, 2012, 04:32:44 PM
Does your new forum ready have existing data? If it does then you will have issues.
Title: Re: Moving part of the database to another forum!
Post by: Malgol on April 30, 2012, 04:35:43 PM
Its a small forum for friends and the new one have 2 members and the Forum set up but it doesn't have the Category that i wish to move yet.
Title: Re: Moving part of the database to another forum!
Post by: Colin on April 30, 2012, 04:39:52 PM
Yes, but the way the database works is not what it looks like from the front end. If you don't know what you are doing I would highly suggest not making this transfer to a non-fresh install.
Title: Re: Moving part of the database to another forum!
Post by: Malgol on April 30, 2012, 04:45:01 PM
The thing is that i have tried to make a transfer to a clean install with crazy results, themes not working as they should, paths not working and so on. =/

It all looks so easy if I only look at the part I want in the db.
Title: Re: Moving part of the database to another forum!
Post by: Colin on April 30, 2012, 04:48:18 PM
This might be something you should consider posting in the help wanted board if you want someone to do it for you.
Title: Re: Moving part of the database to another forum!
Post by: Malgol on April 30, 2012, 04:55:21 PM
The problem there is that I don't have the forum on my server anymore and the one that have the server is slow on getting things done and i don't think he will let anyone else in.

So this is all to find useful information on how it is done if possible.

But it seems strange that a simple input in the database would cause so much problems? Does the forum add thing elsewere when i create a topic or member that does it?
Title: Re: Moving part of the database to another forum!
Post by: Colin on April 30, 2012, 09:31:58 PM
To not get into too much detail, members and categories area given a unique ID which then seperate services within SMF reference. If you were to import members and categories from an old forum to a non-fresh install, some UID's may be duplicate, thus screwing everything up.
Title: Re: Moving part of the database to another forum!
Post by: Malgol on May 01, 2012, 02:10:54 AM
hmm... What if i remove all topics or should there be no Boards or categories? Right now there is only one and the "default" welcome topic anyway.
Title: Re: Moving part of the database to another forum!
Post by: Colin on May 01, 2012, 02:24:44 AM
I will be happy to take a look if you are willing to provide some credentials.