Can't login to dashboard after restoring database.

  • I ran into an issue where I needed to revert back to a old backup of my site. The backup works properly but in doing so I lost users that are imperative to my site. Hoping to restore the users I restored my database to a previous version when I knew I had all the current users. I did the restore through Bluehost.com. The restore worked perfectly and I can even see the users I lost through Bluehost’s WordPress Tool. I went back to my site and tried logging in but am unable to. I’ve searched all day on what to do but am at a loss. I have a feeling the database version isn’t matching up on my wp-config.php but everything looks accurate to me. Has anyone else experienced this issue or have a solution to my problem? I don’t want to revert to an even older backup for fear of losing more users and the database I restored is the oldest version I have. Any help would be tremendous. Thank you kindly.

    Website with issue: https://www.sweetcheeksdiaperbanks.org

    -Mike

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

  • Mike, first, thanks for providing a link to your site. You have no idea how helpful that is when trying to diagnose a problem.

    I wonder if you’ve tried the reset password link?

    If so, & it hasn’t worked, then let’s try the following.

    First, create a backup of your database. Really important! Changes of this magnitude should not be made w/o a backup.

    Once that’s done (you really did back it up, right?), go to PHPMyadmin in your hosting provider’s control panel. Once there, select the database for your site. You can determine that, if necessary, by opening wp-config.php, either via FTP (preferably secure FTP) or via your hosting provider’s file manager.

    Once there, you’ll want to select the wp_users table & click ‘Browse’. You’ll probably see your username/email there, so at this juncture click the ‘Edit’ link. Make any changes. For the password, type in your chosen password, then click in the ‘functions’ dropdown list, & select md5. Once finished, press the ‘Go’ button.

    Please let us know if that does or doesn’t help, ok?

    Thread Starter musicmschell

    (@musicmschell)

    Hi Jackie! Thank you so much for the response. I had a feeling I had to use PHPMyadmin but was a little uncomfortable with using it. Luckily my best friend is a professional database specialist and helped me out last night. He loaded the latest backup I had that included all our users then found the specific users information using PHPMyadmin and exporting those tables. He then reverted WordPress back to another back up a few week prior that was working properly. After that he added the missing users using PHPMyadmin. So far it’s worked well but I will continue debugging until all our issues are sorted out. Thank you again for the advice and quick response. He thinks the issue was that I reverted WordPress back to one date and restored the database to another date. He thinks it might have some version differences or something like that. Either way both of you have a been a huge help. Have a great day!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Can't login to dashboard after restoring database.’ is closed to new replies.