Moving existing WP database to localhost

  • I have a live site and I want to set up a local test site. I have installed xampp and imported my database (extracted from a backup file) but the database points to my existing live host. How/what do I alter so that I can use a copy of my live site on my local machine?

    Thanks

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

  • Have you edited wp-config.php in your WordPress installation? You will need to provide database information for your local database (user, pass, database name, and possibly database server from the sounds of it)

    there are several instances of the hosted url in the db
    the easiest thing to do would be grab the db back up .sql file and open it in notepad or similar plain text editor and do a search and replace with hosted url and localhost url
    import .sql file

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Moving existing WP database to localhost’ is closed to new replies.