vbulletin.com to vbulletin.org splitting

[Areku]

Hi!

I have a board running and I'd like to split one of the subforums to a fully new domain/vB forum site, so if now I have:

domain1.com
|
---forums
|- subforum1
|- subforum2
\- subforum3

...now I want to move subforum2 to domain2.com forum

domain2.com
|
---forums


Much like what happened to the hacks section of vb.com, which is now an independent site, vb.org BUT SHARING THE USERS DATABASE.

Is that possible?

How?

Thanks!

[dotagious]

The two websites do not share a user database.

[Areku]

OH!

And is there any way to do so?

[filburt1]

There is no sane way.

[Areku]

Awesome, fast and clear answer, thanks! ;)


How can I then export the contents of a subforum and then reimport them onto a brand new vb installation? ;)

[filburt1]

Very complicated to explain, but one way is the INSERT INTO...SELECT syntax; check out http://www.mysql.com/doc

[Areku]

Was that ironic? I'm not a php/sql guru...

[Brad]

Then I wouldent recomend attempting this ;)

[Areku]

Why not? I would not delete anything from the first forum and the second forum is empty so where's the risk? ;) Other thing is if any1's so kind to gimme instructions on how to achieve this, even if it's done via phpMyAdmin or something...

[Xenon]

without some experience in php and mysql you won't be able to do so.

well i can tell what was done on vb.org while it was splited from vb.com

make a dump of all thread where forumid was hackforum id
make a dump of all posts belonging to that threads
inserting threads/posts into vb.org db
set thread.postuserid and post.userid = 0

changing register.php when a user registers it updates the postuserid and post.user id of all posts where username = new username.

that's the theory, now feel free to write the scripts around ;)

[Areku]

So in fact if I used my nick on the old forum but now someone elses' register my nick first on the NEW, the posts become his?

[Xenon]

Exactly that was what it was here.

but normaly you should always be the first user who registred on your board ;)

but for every other account you have to trust your users if you want to do it the same way as vb.org here.

another way is to make a complete dump of the db and insert it on the new domain, and then delete all unused forums
it would take some time but is easier to achieve, and your users don't have to register, because they are already ;)

[okrogius]

The easiest way to share a database is just have one database altogether. But have a column in the forum table determining which forums appear on what site (or both).

[Zachery]

i think that there is a sane way, but i also think im not at liberty to say how its done.... maybe im just thinking of something differnt