WPE

gistfile1.txt

/** Procedure for Site Transfer from WPE to Other Host */

(1) Download ZIP from WPE (Backup Points)

(2) Upload WPE ZIP to new server

(3) Create new wp-config.php file with new DB_NAME, DB_USER, DB_PASSWORD, Keys and Salts, and $table_prefix.
	(3a) Add
		define( 'WP_POST_REVISIONS', FALSE )
	(3b) Add
		define( 'WP_AUTO_UPDATE_CORE', false );
	(3b) Move any custom items from WPE wp-config file such as license keys, etc

(4) Create new MySQL database in new hosting account

(5) Import mysql.sql database file (found in wp-content of WPE ZIP) into new DB (phpMyAdmin)

(6) Change table prefix ('Replace table prefix' in phpMyAdmin) to new $table_prefix

	(6a) Edit the WordPress options table and update prefixes to match new prefix
		SELECT * FROM `newprefix_options` WHERE `option_name` LIKE '%wp_%'

	(6b) Edit the WordPress usermeta table and update prefixes to match new prefix
		SELECT * FROM `newprefix_usermeta` WHERE `meta_key` LIKE '%wp_%'

(7) Extract/unzip WPE ZIP file on new server

(8) Replace WPE wp-config.php file with new file

(9) Delete
	/mu-plugins directory
	/wp-content/advanced-cache.php
	/wp-content/object-cache.php
	/wp-content/mysql.sql

(10) Find and replace olddomain.com with newdomain.com using searchreplacedb2.php (http://interconnectit.com/124/search-and-replace-for-wordpress-databases/)