cristiano matos cristiano matos - 4 months ago 14
PHP Question

Website in wordpress redirects to old URL after migration

I had never done migrating a site on wordpress, I'll put step by step how I did, need to put the site on a new domain that are on the same server, so only the migrated files, the database is equal.

I copied all the files from the old wordpress to the new site folder,
I had the following result on the new site:
Home - The site carries the theme but a message appears: 404: PAGE OR FILE NOT FOUND.
newsite/wp-admin/ - redirect to oldsite/wp-admin/

I have the option in the site administrator old put the new URL but I'm afraid I could never access. it can go?

Thanks.

Answer

You need to make a change to your database. In the database table wp_options (or whatever your database prefix is), you need to change two lines.

One should be option_id 1, option_name siteurl. Change the option_value from the old url to the new url.

Similarly there should also be option_id 36, option_name home. Change the option_value also from the old url to the new url.

This should do the trick. Also check out http://wp.smashingmagazine.com/2013/04/08/moving-wordpress-website/ for the best method to migrate.

Edit

In the comments Damon also mentions the issue with re-linking all the images. This for sure can be a right pain, but I suggest this plugin.

http://wordpress.org/plugins/search-and-replace/

Just search for the old url and replace with the new one. Before doing this though, make sure you have a backup of the database. You can never guarantee the results when using plugins to mess with your database. But this has always worked for me.