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======================

MediaTemple 1-click install wordpress

This summary is not available. Please click here to view the post.

MediaTemple Configuration

* php.ini

~/../../etc/php.ini
--------------------------------------------
; Rename this file to php.ini and uncomment or add directives.
; For a complete list of valid directives, visit:
;  http://us2.php.net/manual/en/ini.php

[PHP]
; We highly recommend that you leave this options enabled
cgi.fix_pathinfo=1

; Increase maximum post size
post_max_size = 20M

; Increase execution time
max_execution_time = 300

; pull in EGPCS [Environment, GET, POST, Cookie, Server] variables as globals
;register_globals = true

; For performance reasons, (mt) does not load all of the modules that are available
; into PHP. You may uncomment any one of the following "extension" lines to enable
; the desired module

; Salblotron XSLT
;extension=xslt.so

; save in local tmp
session.save_path=/home/163036/data/tmp

;My Custom
output_buffering = 4096
memory_limit = 128M
upload_max_filesize = 20M
--------------------------------------------

* mysql config <--- no permission to tune
--------------------------------------------
'max_allowed_packet' default 1M
--------------------------------------------