Title: Missing wp_users table
Last modified: August 20, 2016

---

# Missing wp_users table

 *  [smoke1439](https://wordpress.org/support/users/smoke1439/)
 * (@smoke1439)
 * [14 years, 10 months ago](https://wordpress.org/support/topic/missing-wp_users-table/)
 * Hello,
 * Someone thought it would be funny to hack my site and delete my wp_users table
   from my database and now I can’t access my WP. I have it backed up, from a while
   ago, but would like to just restore the wp_users table if possible, but I’m not
   sure how to restore just the one table. If not, just creating the wp_users table
   would be fine, but I’m not sure exactly how to that either and I’m coming empty
   with my searches.
 * Thank you kindly for any advice 🙂

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [14 years, 10 months ago](https://wordpress.org/support/topic/missing-wp_users-table/#post-2179335)
 * If possible, use [phpMyAdmin](http://codex.wordpress.org/phpMyAdmin) to restore(
   phpMyAdmin calls that Import) that one table. The info below assumes your users
   table is called wp_users, but the ‘wp_’ will depend on what your TABLE PREFIX
   is.
 * 1. Make a backup of your database now just in case!!!
    2. Then make a copy of
   your OLD backup that has the wp_users table. 3. Then with something like NotePad
   +, edit that copy and delete everything in the file except for the reference 
   to the wp_users table. Look for the CREATE TABLE for wp_users and that’s the 
   beginning of the records you should KEEP, and KEEP everything up to the next 
   CREATE TABLE statement. 4. Then use the phpMyAdmin Import.
 * Alternative:
    You might consider asking your host if they have a recent backup
   they can restore.
 *  Thread Starter [smoke1439](https://wordpress.org/support/users/smoke1439/)
 * (@smoke1439)
 * [14 years, 10 months ago](https://wordpress.org/support/topic/missing-wp_users-table/#post-2179459)
 * MichaelH,
 * Thanks a bunch for the suggestion. I will give this a try tomorrow afternoon 
   when I have more time and can take it slow. I’ll be sure to make a back-up first.
 * In the mean time, I was able to manually add the wp_users field back into the
   db, so at least I’m able to post for now.
 * Just a thought, should I delete that table before trying to restore it or will
   it just overwrite it?
 * Thanks again!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Missing wp_users table’ is closed to new replies.

## Tags

 * [wp_users](https://wordpress.org/support/topic-tag/wp_users/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [smoke1439](https://wordpress.org/support/users/smoke1439/)
 * Last activity: [14 years, 10 months ago](https://wordpress.org/support/topic/missing-wp_users-table/#post-2179459)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics