Missing wp_users table

  • smoke1439

    (@smoke1439)


    12 years, 9 months ago

    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

    (@michaelh)

    12 years, 9 months ago

    If possible, use 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

    (@smoke1439)

    12 years, 9 months ago

    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