Migrating user data

Question

I am trying to migrate user data. There aer around 500 users that needs to be migrated. Problem is that these 500 users are registered in old site and i cant just insert these to new DB as new users are registered so uid of new user and these 500 users will collide , to avoid these i wrote a script to read all these data again and using user_save i am re inserting them , but the problem is

$new_user = array(
        'name'   => $row[name],
        'mail'   => $row[mail],
        'pass'   => $row[pass],
        'status' => $row[status],
        'init'   => $row[init]
    );

Here 'pass' is already md5 so when saving using $account = user_save('',$new_user); it is md5 hashed again ! Is there a better way to do this ?

Answer 1

I'm not sure if there is a drupal way of doing this that does not use md5.

My first thought is to save the user w/o a password. The user object should then have a uid which you can use in SQL to insert the existing hashed password into the user's password field.

db_query("UPDATE {users} SET pass ='%s' WHERE uid = %d", pass, $new_user->uid);