Brad Touesnard

Chris A. a11n

Allows developers to record queries when setting up a theme or plugins locally, creating an SQL script that can be run later when deploying to a staging or live site.
Interested in contributing to Query Recorder? Please visit https://github.com/deliciousbrains/wp-query-recorder
Banner image credit – <a href="https://www.flickr.com/photos/cmoi/" rel="nofollow ugc">cmoi</a>

Query Recorder

Save queries run by your theme or plugins to an SQL script for deployment

Tyler Shuster

This is a plugin to manage deployment of WordPress sites to one or multiple servers, whether development, staging or production. Add, remove, push to, or pull from environments under Tools -> Deploy.
Requires: 
rsync 
If using ssh and not the command line, must use key-based authentication
Add the following constants to your wp-config.php or add them via the admin interface.
(ENV can be any name of your choosing for your remote environment)
<pre><code>DEPLOY_[ENV]_DB_HOST
DEPLOY_[ENV]_DB_USER
DEPLOY_[ENV]_DB_NAME
DEPLOY_[ENV]_DB_PORT
DEPLOY_[ENV]_DB_PASSWORD
</code></pre>
* Database dsn for the environment 
* Mandatory: Yes except for port (default 3306)
<pre><code>DEPLOY_[ENV]_SSH_DB_HOST
DEPLOY_[ENV]_SSH_DB_USER
DEPLOY_[ENV]_SSH_DB_PATH
DEPLOY_[ENV]_SSH_DB_PORT
</code></pre>
* If you need to connect to the destination database through SSH (you probably do) 
* Mandatory: No, port defaults to 22
<pre><code>DEPLOY_[ENV]_SSH_HOST
DEPLOY_[ENV]_SSH_USER
DEPLOY_[ENV]_SSH_PORT
</code></pre>
* SSH host to sync with Rsync 
* Mandatory: No, port defaults to 22
<pre><code>DEPLOY_[ENV]_PATH
</code></pre>
* Server path for the environment (used to reconfigure the WordPress database) 
* Mandatory: Yes
<pre><code>DEPLOY_[ENV]_URL
</code></pre>
* Url of the WordPress install for this environment (used to reconfigure the WordPress database) 
* Mandatory: Yes
<pre><code>DEPLOY_[ENV]_EXCLUDES
</code></pre>
* Add files to exclude from rsync. List must be separated buy semicolons. 
* Mandatory: No

WP Deploy Flow

This adds functionality that allows developers to pull or push their entire site or only the files from a variety of remote environments.

Query Recorder vs WP Deploy Flow