VBulletin Duplicating Users

demonhale's picture

He has: 3,278 posts

Joined: May 2005

I have read through the VB forums and read about Impex but I am still wondering how to move or copy members from one forum to another forum which are both VBulletins and would have duplicate members, since they are both for the same group of people but wanted different forum niche.

I was wondering if it was as easy us backing up the MySql DB for the users and dropping it to the users DB on the second forum, or are their other ways to do it?

Thanks to those who might give me a hint of idea here...

JeevesBond's picture

He has: 3,956 posts

Joined: Jun 2002

Are you going to be copying the members regularly, or is this just a one-off?

If it's a one-off, just use mysqldump. If not, you could use a script, or see if there's a way of sharing the user tables between the two vBulletin instances.

a Padded Cell our articles site!

demonhale's picture

He has: 3,278 posts

Joined: May 2005

Just this time, a one-off thing. I plan to use Mysqldump, that why I mentioned of backing up my DB and doing it via Sql. But I am not sure if it will be ok by this method and that the databases won't get mangled up from the source and once transferred to the other system.

A script for this is called Impex by VB developers, but it is not 100% safe for all versions for transfer. As I plan to still use both forums but allow the members from the old forum to get access on the new forum as well with their same data etc.

Sharing Tables would be out of the question as I plan to use separate servers to run them.

Thanks for the Tips so far, it reinforces my belief that I will do it the long route via Sql...

demonhale's picture

He has: 3,278 posts

Joined: May 2005

Btw, I had a double post, how do I delete it here in TWF, can't seem to find the edit>delete option...

JeevesBond's picture

He has: 3,956 posts

Joined: Jun 2002

There's no way to delete your own posts in this version of Drupal. Sad

Just put: 'duplicate post,' in the post text and one of us mods will un-publish it. Smiling

a Padded Cell our articles site!

demonhale's picture

He has: 3,278 posts

Joined: May 2005

Gotcha, Thanks... Wink

JeevesBond's picture

He has: 3,956 posts

Joined: Jun 2002

I'd say mysqldump would be the easiest way to do this, yes.

But I am not sure if it will be ok by this method and that the databases won't get mangled up from the source and once transferred to the other system.

Unless you're doing something funky with the vBulletin installation, or there are existing users on the vBulletin you're moving to, then probably not. Smiling

a Padded Cell our articles site!

demonhale's picture

He has: 3,278 posts

Joined: May 2005

We'll after I exhaust all my options, I'll resort to using the mysqldump method, I just need to research what db tables are connected with each other just for the users...

I read on VB Forums some mangled up installations going this route (mysqldump) when running the forum with the user db's with no attached/required db resources aside from the main users db. Confused

They have: 13 posts

Joined: Oct 2008

Duplicate Users are available all the forum how you can find it will very tough task to judge the people that he have many account on single forum.

demonhale's picture

He has: 3,278 posts

Joined: May 2005

Phlip_corter wrote:
Duplicate Users are available all the forum how you can find it will very tough task to judge the people that he have many account on single forum.

Actually it's not about the duplicates in a forum, all forums have some sort of duplicate users. My dillema was to duplicate all the users from one forum to another. Meaning, copy the same users, details, passwords to another forum. User Migration.

They have: 83 posts

Joined: Apr 2009

do you want to import your user from one Vbulletin forum to another vbulletin forum or what? or do you want anything other. if you want to import or export any user to any other forum then do one thing take the backup of the user table from mysql and insert it in your new forum otherwise take the complete backup of your forum and then insert the mysql in to the new forum then your problem will be solved.

They have: 13 posts

Joined: May 2009

I believe you would have to transfer the sql database, but I don't know if there are any other methods.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.