How to Transfer WordPress Users from One WordPress Site to Another

When you want to move users from one WordPress installation to a brand new installation of WordPress, it must be done via the database.

Only transfer users to an empty database. If you transfer users to a database that already contains users, existing users will be lost.

Step 1: Export WordPress Users

You can transfer your WordPress users from one site to another site by performing the following steps:

  1. Log into cPanel.
  2. In the Databases section, click the phpMyAdmin icon.
  3. From the left navigation menu, select the database that the users are being exported from. Ex. cPanelname_wrdp1.
  4. From the top navigation menu, click Export.
  5. Select the radio button for Custom. Additional options will appear.
  6. Under Object creation options, check the boxes for Add DROP TABLE statement and Add CREATE PROCEDURE / FUNCTION / EVENT statement.
  7. Click Go.  
  8. Save the file to your local computer.  It will be needed later.

Step 2: Import Users to Destination WordPress Site

In the database of the destination WordPress site:

  1. From the top left navigation menu, click the Home icon.
  2. From the left navigation menu, select the database to which the users are being imported.
  3. From the top navigation menu, click Import.
  4. Under File to Import, click the Browse button.
  5. Select the file that was previously downloaded and saved on your local PC in Step 1 above.
  6. Click OK.
  7. Click Go.

After completing the steps above, the users from your old WordPress site should have been successfully imported to your new WordPress site.