Training

When: Every first Sunday of every month -get a ticket- from $15 (Click Here).

Tuesday, November 7, 2017

Exporting, Importing, migrating users in wordpress | phpmyadmin

Exporting and importing users from wordpress to wordpress

  1. wp_users is the primary table, with a fixed list of columns.
  2. wp_usermeta is an additional table for storing arbitrary information (custom fields).
  3. The wp_users table already has a user_email column, so I don't know why the plugin uses wp_usermeta. I guess the best person to ask would be the plugin author himself.

Descriptions:
  • WP1= my old site
  • WP2= my new site

Tables:
wp_user and wp_usermeta (you need to change the wp_ if needed)

Export
from WP1 wp_user and wp_usermeta (separatly)
download the 2 sql files

Prepare sql files:
  1. In gedit do Ctrl+H (find and replace)
  2. replace database name
  3. replace tables changes (may be from wp_ to what_ever_your_string)
  4. save and keep

Upload:
  1. Go to your dtabase for WP2
  2. do a backup of the dB
  3. delete tables wp_user and wp_usermeta
  4. import new (fixed sql files) for wp_user and wp_usermeta
  5. test
  6. evaluate database



No comments: