Drupal to WordPress migration: user table mapping

This is part four of a series of posts documenting the table mappings for a site migration from Drupal 6 to WordPress 3. For more information, please see the first article in the series.

Table mapping for WordPress users

This maps Drupal user export to WordPress.

Drupal 6.x	WordPress 3.x	Notes
users	wp_posts
uid	ID
name	user_login	Format to lowercase, replace spaces with underscores
pass	user_pass
name	user_nicename
mail	user_email
created	user_registered	Formatted from UNIX time
name	display_name
	user_status	Whitespace string
	user_activation_key	Set to 0

Table mapping for WordPress user meta values

User information like capabilities and roles in the wp_usermeta table.

users	wp_usermeta
uid	user_id
	meta_key	Set to string e.g. ‘wp_capabilities’
	meta_value	Set to string e.g. ‘a:1:{s:6:”author”;s:1:”1″;}’

More information about the settings for appropriate meta_key and meta_value can be found in the WordPress Codex:

• Roles and Capabilities
• User Levels

Node authors and comment authors

Drupal stores both node authors and comment authors in the users table. WordPress handles things differently. Page and post authors are stored in the wp_users table but comment authors are stored in wp_comments together with the comment data.