Manully Moving WordPress Site to Localhost

  1. FTP the files to your localhost directory.
  2. Import the the MySQL dump of the live site.
  3. Change the “wp-config.php” file settings to reflect your new hosting information.
  4. Lastly run the following SQL statements to update links in the database.

UPDATE wp_options SET option_value = replace(option_value, ‘’, ‘http://localhost/test-site’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

UPDATE wp_posts SET post_content = replace(post_content, ‘’, ‘http://localhost/test-site’);

UPDATE wp_postmeta SET meta_value = replace(meta_value,’’,’http://localhost/test-site’);

The first update command didn’t work for me. I believe the person who set up the changed the default home page to be something else. I fixed this by going into the database, and under the table wp-options I was able to set this manually. I then logged into the back-end of the site and under Settings >> General. I manually typed in my localhost address in the “Site Address (URL)” field.

I found the following link that helped me out.

I hope this helps someone else out there….


Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>