Answers.Body: <p>The Standalone extension repurposes the <code>civicrm_uf_match</code> table (which on CMS-based instances of CiviCRM stores a link to the CMS user record) to store username, password, etc. To stay consistent the tablename is still <code>civicrm_uf_match</code> but it get's labeled &quot;Users&quot;.</p>
  <p>Installing the standalone extension will delete and rebuild this table with the extra columns. If you have existing users to migrate you can then insert them into the table post-install. Every other table is the same, so migrating from another site should be as straightforward as a sql dump.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-02-16T21:11:42.660Z
Answers.Text: Thank you, @Coleman. Quick follow-up: does the Standalone version use the same password hashing method as Drupal? Can I simply copy the Drupal.users "pass" field into the hashed_password field of civicrm_uf_match?
Answers.UserDisplayName: Paul B
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-02-17T20:12:13.167Z
Answers.Text: I believe it is the same
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-02-15T17:59:47.220Z
Answers.LastActivityDate: 2024-02-15T17:59:47.220Z
Answers.UserDisplayName: Coleman
Body: <p>I'm starting to test out Civi Standalone (something we've been waiting for, glad it's moving forward!) and I wanted to see how we might be able to migrate our data from a Drupal instance to the standalone instance.</p>
  <p>I'm not sure if it's as simple as a mysqldump from the Drupal instance and loading to the standalone, as I believe standalone includes tables/data of the user accounts to log in.</p>
  <p>Is there a way to migrate to a standalone instance? How do we migrate users? Also, where are the users in Standalone even stored (which db tables)?</p>
  
Tags: <standalone>
Title: Migrate from Drupal to Standalone
ThreadText: # Migrate from Drupal to Standalone
  
  (Asked by: username_0 on 2024-02-14)
  
  I'm starting to test out Civi Standalone (something we've been waiting for, glad it's moving forward!) and I wanted to see how we might be able to migrate our data from a Drupal instance to the standalone instance.
  
  I'm not sure if it's as simple as a mysqldump from the Drupal instance and loading to the standalone, as I believe standalone includes tables/data of the user accounts to log in.
  
  Is there a way to migrate to a standalone instance? How do we migrate users? Also, where are the users in Standalone even stored (which db tables)?
  
  **Tags:** standalone
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-02-15. Score: 2
  
  The Standalone extension repurposes the `civicrm_uf_match` table (which on CMS-based instances of CiviCRM stores a link to the CMS user record) to store username, password, etc. To stay consistent the tablename is still `civicrm_uf_match` but it get's labeled "Users".
  
  Installing the standalone extension will delete and rebuild this table with the extra columns. If you have existing users to migrate you can then insert them into the table post-install. Every other table is the same, so migrating from another site should be as straightforward as a sql dump.
  
  > **Comments:**
  > **username_0**: Thank you, @username_1. Quick follow-up: does the Standalone version use the same password hashing method as Drupal? Can I simply copy the Drupal.users "pass" field into the hashed_password field of civicrm_uf_match?  
  > **username_1**: I believe it is the same  
  
  ---
  
  