PDA

View Full Version : How to merge user tables?


badboyz
10-24-2007, 02:11 AM
Hey

i have 2 different user tables. how can i merge them together?

I only have the user table

Marco van Herwaarden
10-24-2007, 07:32 AM
You don't have the other tables? Are these both vBulletin user tables?

badboyz
10-24-2007, 01:14 PM
Yes
both are VB user tables.

I have all other tables for a database but for the other one i only got user table.
Can you help me?

--------------- Added 1193279966 at 1193279966 ---------------

anyone?

Marco van Herwaarden
10-25-2007, 07:32 AM
If you don't have the other tables (wonder why not if this is your own data), then your best option would be to restore that table into some database (make sure you don't overwrite your current user table), export it to a CSV text file and use the ImpEx text file importer to add the users to your current board.

badboyz
10-25-2007, 10:25 PM
Noo,

I had my old database which i was not able to restore it so i started a new site again with a new db,but i lost lot of members so i just want to add those members again

Im using the new database now.how would i import the old database user table into the new one now?

I want to mix the two database together.

Paul M
10-25-2007, 10:42 PM
Restoring old members is not as simple as just adding old user table records - a lot of other tables need corresponding records as well. You will almost certainly also get userid clashes.

badboyz
10-26-2007, 01:35 AM
Oh...

So there is no way i could do this?

Marco van Herwaarden
10-26-2007, 07:11 AM
See post #4.