Hi.
If you have problem with your website migration, at least you will see can’t connect to the database error notification or sometime your website still redirected to your localhost, or maybe your website CSS is not worked.
But if you got can’t connect to server, I think the issue is at your webhosting or the domain name configuration.
Please check your domain nameserver and make sure it already pointed to the right server.
Hi brainesia, thank you very much for your advice. It’s not a remote server or domain problem because I am working from my own computer, which is why I specified that I’m using MAMP and Sequel Pro. I’ve not resolved the issue, but I decided to just load the whole thing up onto the *remote* server (something I thought would be more difficult). After a few hiccups it did eventually work. Still no idea why it won’t work locally though.
Thanks again.
Niall
My bad, I think you want to move your site from localhost to remote server.
If you want to moving website to your localhost, please make sure you create virtual host in your MAMP https://www.google.com/search?q=mamp+create+domain or you can change the home and url value inside wp_options table. Usually you should change it to http://localhost/, depend on your main directory location. But it’s better if you create virtual host.
HI Niall,
Not sure what the purpose of Sequel Pro would be in a local MAMP setup as MAMP is all you need 🙂
If you have done a default MAMP install, that is, you have not adjusted the document root nor the Apache port, then it is really simple:
– create a folder within Applications/MAMP/htdocs and name it something relevant, but without spaces (e.g. mysite for this example)
– copy your site files to this folder
– using phpMyAdmin from the MAMP Start Page Tools menu, create a new, empty database (for this example, name it mysite … again, no spaces)
– select this new database and import the exported .sql file
– edit the wp-config.php file now in the /mysite folder with the default MAMP settings:
— database name: mysite
— database user: root
— database password: root
— host name: localhost (or 127.0.0.1)
— table prefix: if your live site had a table prefix other than wp_ then enter that value here
To access your local site:
http://localhost:8888/mysite
Add /wp-admin or /wp-login.php after the above URL to access the WP log in.
Once logged in, you will need to install and run this plugin to update the URLs:
http://wordpress.org/plugins/velvet-blues-update-urls/
— select all options EXCEPT the last one (GUID)
Once that is done, go to:
Settings > Permalinks and Save.
Thanks very much for your detailed response. It’s much appreciated. I used Sequel Pro as I was following a video tutorial. It worked for me a couple of years ago, but not done much WordPress stuff since, so I’m afraid I’m a bit rusty.
As I say, the website worked fine when I just uploaded to the new remote server and imported the old sql database file. I think I was making life harder for myself. But I would like to get to the bottom of what the problem was, so I’ll give this a go when I’m back at work Tuesday. Many thanks.
Niall
