Uploading a WordPress Site

Overview

Documentation of necessary steps for uploading a WordPress site.

Workflow

• Upload the WordPress files
  • Edit /[WP_ROOT]/wp-config.php to update the DB_HOST definition with the correct database server value for the production environment.
  • The optimal way is to put the WordPress directory in a tarball, upload, and extract. This requires SSH on the remote server.
  • Make sure to upload a .htaccess file that will handle requests based on page names.
  • Take care to include media uploads ([WP_ROOT]/wp-content/uploads/)
• Export the staging WordPress database.
  • Make certain the client has stopped updating the content of the site.
  • PhpMyAdmin on local machine.
  • My_WP_Database > Export > Default settings > save as .SQL file
  • Do a search and replace on the exported file, replacing the staging domain name with the production domain name.
• Import the staging WordPress database.
  • Using PhpMyAdmin on the production server, login and select the WordPress database.
  • Click the import tab and then select the .sql file exported from staging.
  • Use default settings for import.