How easy is it to import the Nuke_users into

Client Joined: Jul 18, 2003 Posts: 977

a brand new db for another site? I have two sites and I would like the users from one to be users on the new without re-registering. Is it as easy as running the Insert sql from one to the other? What information is retained/lost? Thanks.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Yep. Export your users table and drop it into the SQL window of your new site. The only issue you might have is if the prefix is not the same, in which case you mass change it in your editor.

Posted: Wed Nov 10, 2004 2:14 pm

Okay, thanks for the heads up on the prefix... Okay I see that everything about a user is in that... so I could import them and then how do I zero everything out such as post count and comment counts and stories published? Things like that... I would like to retain the users but none of the things they did on the other site. Thanks.

Posted: Wed Nov 10, 2004 3:00 pm

UPDATE nuke_users SET user_posts=0;

Posted: Wed Nov 10, 2004 9:19 pm

Thank you!