Ready to get started?Download WordPress


password issue going from production to local (7 posts)

  1. Pvteyez
    Posted 1 year ago #

    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.

  2. Ed Gray
    Posted 1 year ago #

    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 (http://wordpress.org/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 (http://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.

  3. Pvteyez
    Posted 1 year ago #

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

  4. Pvteyez
    Posted 1 year ago #

    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!

  5. Ed Gray
    Posted 1 year ago #

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

  6. Wil
    Posted 1 year ago #

    @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 http://stagingservername with http://www.productiondomain.com
    4. Import the new SQL to the new DB


  7. Pvteyez
    Posted 1 year ago #

    Thank you for that Lime Canvas

Topic Closed

This topic has been closed to new replies.

About this Topic