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