Support » Localhost Installs » wp-users table missing

  • I have a client that is running 3.3.1. I need to make a local development copy of their site so I can update it and make some changes. So I copied all the files, exported then imported the database, updated the wp-options table.

    I am able to access the homepage on my local copy. I can also see the log-in screen under wp-admin, but I can’t log-in. I went to reset my password in the wp-users table, but it didn’t exists. So I checked the live site database to see if I just missed this table somehow. But it’s not on the live site either. But the live site allows me to log-in to the backend.

    Is there another place that user-data is stored in WordPress 3.3.1?

    I have no idea where to go with this, so please, any help at all would be greatly appreciated.


Viewing 5 replies - 1 through 5 (of 5 total)
  • esmi


    Forum Moderator

    Are you sure you looked for wp_users and not wp-users?

    My bad, I said ‘wp-users’ but I meant ‘wp_users’. There is no ‘wp_users’ table in either site.

    I tried copying the wp_users table from another install. But when I try to log-in, I just get a message that says that I don’t have permission to access that page.

    I also tried opening the file that I exported from phpMyAdmin and searching for my username, but it wasn’t found.

    Is there a PHP file that I can modify to see what database/table the site is actually using for the users?




    Forum Moderator

    There is no way that a standard WordPress site could possibly run without a wp_users table. Did you install WordPress on this domain yourself?

    No this is a new client. I know what you’re saying, and I can’t figure out how it’s working. There are 270 tables in this database, I’m guessing that whoever developed this site must have modified the core files to use another table. But I did search the DB for my username and it’s not there. I just don’t understand how this could be working.

    I was thinking there may be 2 databases and I just pulled the wrong one, but I used the client’s login to access the DB through their control panel with Media Temple. There’s only one database on their hosting package and the hostname in the wp_config file is a Media Temple site. So I’m not sure where else to look.

    Thanks again for your help.

    I just installed a plug-in called “Database Browser” and I can see that there is a wp_users table. But I can’t figure out why I’m not seeing it in phpMyAdmin.

    I’ve downloaded another plug-in that’s called ‘wp-dump’ and I exported the database. I’m updating my local copy and hopefully this will work.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘wp-users table missing’ is closed to new replies.