Skip to content

Instantly share code, notes, and snippets.

@atxiii
Last active November 2, 2020 16:35
Show Gist options
  • Save atxiii/00915068d0122e07e7f72b904923b8b4 to your computer and use it in GitHub Desktop.
Save atxiii/00915068d0122e07e7f72b904923b8b4 to your computer and use it in GitHub Desktop.
Update Manually WP_USER AND WP_USERMETA
#WP_USERS
INSERT INTO `wp_users`(ID,user_login,user_pass,user_nicename,user_email,user_url,user_registered,user_activation_key,user_status,display_name) VALUES
(4,'aaa','$P$BmPs7v0824pjqq1bY7WZsKtl0qjw0x0','aa','daphne@aa.com','''','2019-07-01 03:45:13','''',0,'The aa') # yourdata
ON DUPLICATE KEY UPDATE
user_pass=VALUES(user_pass),
user_nicename=VALUES(user_nicename),
user_nicename=VALUES(user_nicename),
user_email=VALUES(user_email),
user_url=VALUES(user_url),
user_registered=VALUES(user_registered),
user_activation_key=VALUES(user_activation_key),
user_status=VALUES(user_status),
display_name=VALUES(display_name);
#WP_USERMETA umeta_id user_id meta_key meta_value
INSERT INTO `wp_usermeta`(umeta_id,user_id,meta_key,meta_value) VALUES
(158,4,_um_last_login,1575947606), #your data
ON DUPLICATE KEY UPDATE
meta_value=VALUES(meta_value)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment