Can you Recover a WordPress User from a Backup

I just did a test on WordPress 5.4.2. I made a new user, and then made a post and a page from that user, then deleted the user and chose not to reassign content to another user.

I looked in the database and found that the data in wp_users for the user was completely deleted, but in wp_posts the content created by that user was still there but set to trashed.

So, you may find that you can recover the posts/pages from the trash, however if they’ve been deleted from the trash they might be gone permanently.

You can always recover data from backups manually, however it would be quite a manual process to find the data from the backup and re-inserting it into the database manually, or re-entering it through the WP dashboard.

For more help see if you have a database backup that you can look at in a text editor and search for your wp_posts table to see if you can find where that information is, and paste an example of it here.

Related Posts:

  1. How to migrate wordpress users from one blog to another
  2. If the current user is an administrator or editor
  3. How do I add a field on the Users profile? For example, country, age etc
  4. user_login vs. user_nicename
  5. WordPress usermeta scaling for thousands of users
  6. Groups of capabilities: users with multiple roles?
  7. Is there a way to merge two users?
  8. How to restrict access to uploaded files?
  9. Best way to send users password?
  10. Why are user address fields required [closed]
  11. Multi-steps WordPress registration : in 4 steps how to?
  12. Allow guests to save favourite pages?
  13. Basic auth WordPress REST API dilemma
  14. Remove all users from site except one using WP CLI
  15. security+best practices: root or www-data on a wordpress content folder?
  16. Show Biographical Info while creating new user
  17. importing users where password is provided as md5 + much metadata
  18. User File Upload Repository?
  19. How to get user ID during registration and add it to a custom table
  20. How do I properly format the user_role array?
  21. How can I secure a WordPress blog using OpenID from a single provider?
  22. How to edit user_id on the comment edit screen
  23. Redirect after login based on user role (custom login page)
  24. get_users() ORDER BY Not Working
  25. Can I create users that have access to *some* other users posts instead of all other users posts?
  26. My custom page template with is_user_logged_in() does not detect that I’m logged in
  27. Total Word Count For Posts And Comments By One Author
  28. Delete user from frontend
  29. Tagging users in WordPress
  30. Share user table from WP with Drupal
  31. WordPress User getting added with id of 0
  32. Log all users out of all locations after 24 hours
  33. Force logout ALL users at a certain time
  34. Show MD5 Password in user section
  35. RSS feed for a given user’s post?
  36. add_cap not working with Shop Manager role
  37. Plugin for limiting user registration based on ip with expiry period?
  38. Bulk delete users from a csv list
  39. Get tags for current user
  40. how to update or refresh the wp user object?
  41. Users managed to register on website with no register button?
  42. Is there a way to make custom fields only editable by administrators?
  43. How to use WordPress for class notes?
  44. Including users in insert link internal link search in Gutenberg
  45. How to Check User type from the form user registers in user_register hook?
  46. Add value in user table when user is created
  47. How to hide WordPress users’ names externally?
  48. Editable registration date field in user profile
  49. How do I transfer user passwords from one WordPress site to another?
  50. How can I authenticate user credentials against a WordPress instance?
  51. Add a role and give admin priviledges
  52. WordPress registration without wp-login.php and wp-admin folder, is it possible?
  53. List users by meta_key and meta_value
  54. MySQL query to mass change role of users
  55. WordPress SQL Issue not returning correct reselts
  56. How to get last user with wpdb?
  57. How to Create a User Profile Page?
  58. List Users alphabetically with heading
  59. How to default/force the user’s display_name to their nickname?
  60. Restrict access to non-wordpress section of site with user roles?
  61. how to remove email field from default user registration form on wordpress
  62. How can I change “Users” related labels in the wordpress dashboard
  63. Does it matter if the very first user, usually Admin, does not have a user ID of 1?
  64. How to set default’ => $current_user->user_login
  65. User can manage one page accessible by everyone?
  66. How to add an attribute to a user?
  67. Can i use two different user tables for on WP install?
  68. SELECT from wp_users, get Displayname too
  69. Redirect current user to their most recent custom post
  70. how redirect users to custom login page when “login to reply” is clicked? [duplicate]
  71. Making WordPress available while logged into another website
  72. Get user ID when action row link is clicked
  73. Advanced Custom Fields Plugin: how would I get an image src path uploaded from User Profile?
  74. Whenever I got to my new pages (http://www.cwmags.com/news) it requests login?
  75. how to delete in phpmyadmin sql – all users with certain condition and all dependencies
  76. How to display a calendar with events depending on the user?
  77. How to show different pages for different users
  78. How can i display pagination in custom comment list?
  79. hide page menu from admin panel for specific users
  80. Disabling user capability to edit_posts or delete_posts in the front-end
  81. Redirect /member/ to /member/user
  82. get user id in a plugin without a function
  83. $user_login is not working if author has only 1 post
  84. WP_User object behaving strangely when used inside Admin Panel?
  85. REST_query_vars for users
  86. How to use a transient inside WP_User_Query
  87. Allowing users to edit only their page and nobody else’s
  88. Add an ‘edit profile’ page with Genesis
  89. Exclude Current user email and send notification
  90. Insert query not working for non-logged in user
  91. Disallow user registration/checkout via Hotmail/Yahoo
  92. User management missing after migration to new host
  93. Add new user and user bio at same time
  94. Validate user meta and redirect
  95. Let admin users edit member profiles from front end
  96. What techniques can a user employ to achieve a password rated “strong” in the WordPress password checker
  97. WordPress – Security Question at Login from User’s Meta Data
  98. determine active user browser at the same time
  99. get Discussion setting in wordpress
  100. Remove My Account Menu items in Woocommerce based on user roles