The Way in Change Wordpress Site URL

→ Ref. http://codex.wordpress.org/Changing_The_Site_URL
→ From URL: www.aaa.com
→ TO   URL: www.bbb.com


********************************************
* Notice  Step 0  -->  Change URL (www.aaa.com)  *
********************************************
※ To Change Jetpack STAT.
1. Before backup : Settings > General > Change URL > Save
OR
2. (Optional) :
   (1)After The following procesure
   (2)Prepare "temp.bbb.com"
   (3)"Settings > General > Change URL to "temp.bbb.com" > Save"
   (4)"Settings > General > Change URL to "www.bbb.com" > Save"
Or
3. (Optional) :After The following procesure, discconnect jetpack and recooncet but you will "lose all your stat data".



********************************************
*                       Backup (www.aaa.com)               *
********************************************
1. backup mysql db
2. backup php files

********************************************
*                                    Setup                              *
********************************************
3. dns setup
4. VPS setup(vhost,db) - bluehost or MediaTemple, etc..

********************************************
*                                     Files                              *
********************************************
5. upload php files to target server(verify the .htaccess setting)

********************************************
*                         DB (www.bbb.com)                   *
********************************************
6. Modify wp-config.php(DB Conection)
7. import db to target db
8. Modify DB Records for New URL(SQL command): Just Update the following-- Otherwise it could be harm to your DB integrity!!
-----------------------------------------------
UPDATE `wrd_options` SET `option_value` = REPLACE( `option_value` , 'www.aaa.com', 'www.bbb.com' ) WHERE `option_name`='siteurl' or `option_name`='home';
UPDATE `wrd_posts` SET `post_content` = REPLACE( `post_content` , 'www.aaa.com', 'www.bbb.com' );
-----------------------------------------------
********************************************
*                       Finalizing (www.bbb.com)            *
********************************************
9. Administration Panels go to Settings > General > Check URL > Save
10. Manually Tune Theme(Check if Old URL Exists)！
-----------------------------------------------
● To fix widgets that contain outdated URL's, you may edit them in Dashboard > Appearance > Widgets.
● Check Template Files:sidebar.php and footer.php
-----------------------------------------------
11. Redirect : www.aaa.com redirect → www.bbb.com (via .htaccess)
12. Check Wordpress.com Stat after view hours and days (Jetpack) <-- See Step 0
13. Re-gen Sitemap

===================Note======================
1. Fix the Incoming Links URL. (Dashboard screen, at Incoming Links. Hover over the area to the right of "Incoming Links" to reveal the "Configure" link. Edit the URL to reflect the new site address.)
2. Do a FULL database(adminer.php) search for any items left.
-----------------------------------------------
● This is optional because 99.9999% done with previous step), but don't change any other field especially meta data such as 'a:4:{s:5:"child";a:1:{s:0:"";a:1:{s:3"rsxxxx'
● Recommend Tool --> adminer.php to search ; phpmyadmin to manipulate
-----------------------------------------------
3. Verify that the reference in your WordPress URL contains the new address.
4. Verify that the reference in your "Blog URL" contains the new address.
===================Note======================