Website in wordpress redirects to old URL after migration

I've solved my issue with my solution at No# 04 See below what I tried:

1- Make sure Database wp_option links are set

/* MySQL: */update wp_options set option_value = 'http://example.com' where option_name = 'siteurl';update wp_options set option_value = 'http://example.com' where option_name = 'home';

2- Additionally define url in wp-config.php file

define('WP_HOME','http://example.com');define('WP_SITEURL','http://example.com');

3- Clear cache of from server

4- Clear your browser cache & history (Hurray!!! it solved my issue no redirection)

On Chrome, Navigate to chrome://settings/clearBrowserData and clear image and file cache.

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.

I think i need to give my contribution! In case you are using Polylang with a dynamic IP, add define('PLL_CACHE_HOME_URL', false); in your wp-config.php and it will solve all your problems (redirection to the former url)!