I’m trying to move a WordPress installation in a web hosting to a localhost installation for development.
I followed this tutorial (Section Manually Move a Live WordPress Site to Local Server, for now I’m not allowed to install plugins, so I must do it manually).
I’m using MAMP Free edition and followed all the steps in the aforementioned tutorial. But when I tried to open the site in the local installation I got the message (In Safari):
Safari cannot open the page “localhost/sitename” because cannot be connected to server “localhost”
- How to update media links in WordPress after migration?
- How do I save a wordpress theme's files and install them on another site?
- Migrating old posts to new wp, how to extrapolate infos from the post body to custom fields?
- How to automatically update on localhost after editing files
- Error after moving WordPress installation
- Migrate different author's content to current author
MAMP load sites in
localhost:8888/<site-name> so i executed:
UPDATE wp_options SET option_value = replace(option_value, 'http://www.thesite.com', 'http://localhost:8888/localsite') WHERE option_name = 'home' OR option_name = 'siteurl';
thesite is the name in the web hosting and
localsite is the name of the folder in
MAMP/htdocs/ where I moved the site’s files.
The only weird thing I noted is that the exported DB from the live site does not have a
home option in
wp_options. I don’t know if it’s a required row, but the online site was working without it.
What am I missing here? If I followed the tutorial correctly, it should load the site.
If you need some more info about the problem just let me know. Thanks in advance for your answers.
siteurl in your
wp_options table is not enough unfortunately. You will still have your post content with your non-localhost URL (
http://www.thesite.com) causing your website to not display properly on your localhost.
You should have the
wp_options table on your localhost copy. Everything should be intact. To make sure exported your database from your live site correctly, please follow these quick instructions provided by WordPress.
Once you’ve downloaded and imported your database to your localhost. Follow these steps:
http://localhost:8888/localsite/replace) and you will see the search/replace tool
search for…field and the new URL in the
You can click the dry run button under actions to see what it will be replacing before you execute the script. Once you’re done be sure to remove the