password issue going from production to local

  • I have wp set up locally. When I download a backup of my site and import it, I log in and of course it takes me right back to the commercial site. When I change the home and siteurl in wp_options I try to log in and get a password failure whether I use the local passord or the production password (which I assume is what I imported with the database). What else do I have to change besides wp_options in order for this to work on my local machine?

    I don’t want to make any changes locally and upload them until I get this figured out for fear I’ll wind up locking myself out of the production environment.

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

  • How exactly are you backing your site up and setting it up locally? The built in import/export tools simply import and export the content. You’ll have to setup the user accounts and passwords separately.

    If you want to duplicate a site to work on it locally, I would recommend using other plugins made specifically for that purpose which duplicate or backup the entire site (content, themes, widgets, database, etc.) and let you restore it to a different server. Domain name changes are handled automatically.

    A popular free tool is Duplicator (https://www.ads-software.com/support/plugin/duplicator). Very easy to use. If you are duplicating the site locally you’ll need a local host environment which you can easily setup with Xampp, MAMP, WAMP, Bitnami or InstantWP.

    BackupBuddy is a popular premium plugin that does the same thing plus scheduled backups to any other location (https://ithemes.com/purchase/backupbuddy/). It starts at $75/yr.

    If you plan on doing this often, an excellent tool for local development then publishing online is DesktopServer by ServerPress.com. It costs $50 for the premium version and supports importing backups from Duplicator, ManageWP and InfiniteWP. It creates its own hosting environment so there is no need for MAMP, Xampp, etc. There is a Windows and Mac version. The free versions of Managewp.com and infinitewp.com let you do manual backups of your site.

    Thread Starter Pvteyez

    (@pvteyez)

    Thanks for the reply. I’ll try that free plugin first and see if that does the trick

    Thread Starter Pvteyez

    (@pvteyez)

    Can’t thank you enough for pointing me to that duplicator plugin. I spent 5 days beating my head against the monitor over that one. The plugin solved it for me in about 15 minutes!

    I’m glad I could help out. That’s what these forums are all about.

    Wil

    (@limecanvas)

    @pvteyez I know your issue is resolved but I thought I’d chip in with an alternative method.

    Our setup uses a local, staging and production model so I’m always moving DB’s from one machine to another.

    I do it manually.

    1. Export your DB from PHPMyAdmin using @replace
    2. Load into notepad
    3. Search and replace https://stagingservername with https://www.productiondomain.com
    4. Import the new SQL to the new DB

    Simples!

    Thread Starter Pvteyez

    (@pvteyez)

    Thank you for that Lime Canvas

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘password issue going from production to local’ is closed to new replies.

Tags