How to Move a WordPress Blog to a New Domain or Location
Before trying the queries in this page, I recommend you to read this full article to learn more about the process.
To update WordPress options with the new blog location, use the following SQL command:
1UPDATE wp_options SET option_value = replace …
