Editing Uploading a WordPress Site (section)

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

[[Category:WordPress]] [[Category: Web Development]]