Skip to content

Instantly share code, notes, and snippets.

@WebEndevSnippets
Last active December 28, 2017 15:22
Show Gist options
  • Save WebEndevSnippets/87798041fc0c50adbda5 to your computer and use it in GitHub Desktop.
Save WebEndevSnippets/87798041fc0c50adbda5 to your computer and use it in GitHub Desktop.
WPE
/** 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/)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment