By pavloukos on

Hi,

I have a question about user transfers between drupal 6.x installations. I have 2 separate 6.x drupal installations, each with different modules installed however.
I would like to transfer a user account from my first drupal installation to my second one.
Can I just copy the corresponding database record from the user table and paste it to the second database's user table? I would like a fresh copy, meaning I just need to copy only the necessary details (name, email password) - basically I would like to retain the password. Is there some module that can achieve this or should I do this manually as described above?

Regards

⋅ Categories: Drupal 6.x

Comments

matkeane’s picture

matkeane commented

Yes, you can just do an insert into the second site with the row from the users table in your existing site and it will retain the same password. If you're using roles, you'll might need to copy any data about them across as well.

One problem is that your two users won't be synchronized. Any subsequent changes - like a new password - won't be reflected on the other site. If you want to share all your users between the two sites, you could share the users database table across both sites, but it sounds like a quick database insert will do what you're after.