RocketModule - svn http://rocket.local/categories/svn en Provisioning and install script for a speedy Drupal workflow http://rocket.local/blog/provisioning-and-install-script-speedy-drupal-workflow <div class="field field-name-body field-type-text-with-summary field-label-hidden"><div class="field-items"><div class="field-item even" property="content:encoded"><p>I made this script and the <a href="/database-backup-dump-and-svn-commit-script-drupal-workflow">database backup, dump, and SVN commit script</a> because I was determined to spend as little time as possible doing sysadmin while setting up dev and staging sites, so that I could spend as much time as possible developing (e.g., the fun stuff). With one command the script can:</p> <ul><li>'svn up' a version controlled database, and upload it to your database</li> <li>Run queries against database to set preferred site defaults</li> <li>'svn up' site docroot</li> <li>Copy over fresh "files" directory from another site (e.g., production). Note, not a good option if you have your "files" directory version controlled.</li> <li>Set owner:group file permissions on all site files</li> </ul><p><strong>How to</strong><br /> The script should go in non-public, secure directory, which is somewhere below the site doc root. I haven't tried running it with permissions less than sudo, though it may be possible. Invoke by doing:</p> <p><code>sh path/to/provision_and_install.sh</code></p> <p><strong>Download</strong><br /><a href="/downloads/provision_and_install.sh.zip">provision_and_install.sh.zip</a></p> </div></div></div><div class="field field-name-taxonomy-vocabulary-1 field-type-taxonomy-term-reference field-label-above"><div class="field-label">Categories:&nbsp;</div><div class="field-items"><div class="field-item even"><a href="/categories/drupal" typeof="skos:Concept" property="rdfs:label skos:prefLabel">Drupal</a></div><div class="field-item odd"><a href="/categories/mysql" typeof="skos:Concept" property="rdfs:label skos:prefLabel">MySQL</a></div><div class="field-item even"><a href="/categories/development" typeof="skos:Concept" property="rdfs:label skos:prefLabel">development</a></div><div class="field-item odd"><a href="/categories/sysadmin" typeof="skos:Concept" property="rdfs:label skos:prefLabel">sysadmin</a></div><div class="field-item even"><a href="/categories/svn" typeof="skos:Concept" property="rdfs:label skos:prefLabel">svn</a></div></div></div> Sat, 28 Mar 2009 17:33:42 +0000 Caleb Gilbert 88 at http://rocket.local http://rocket.local/blog/provisioning-and-install-script-speedy-drupal-workflow#comments Database backup, dump, and SVN commit script for Drupal workflow http://rocket.local/blog/database-backup-dump-and-svn-commit-script-drupal-workflow <div class="field field-name-body field-type-text-with-summary field-label-hidden"><div class="field-items"><div class="field-item even" property="content:encoded"><p>This script is useful for keeping a database within reach of an 'svn up' anywhere it needs to be deployed (e.g., dev and staging sites). In addition to creating a database dump, it also svn commits the database. I use it in conjuction with this <a href="/provisioning-and-install-script-speedy-drupal-workflow">provisioning / install script</a>, but it can be used on its own.</p> <p><strong>How to</strong><br /> The script should go in non-public, secure directory, which is somewhere below the site doc root. I haven't tried running it with permissions less than sudo, though it may be possible. Invoke by doing:</p> <p><code>sh path/to/dump_and_checkin.sh</code></p> <p>It has logging and verbose output for confirmation of it's operations on the command line.</p> <p>Future possiblities includes doing something <a href="http://www.petersblog.org/node/959">like this</a> to cut down on the size of the diffs committed, but since haven't gotten a chance to test that in a prodcution environment, am sticking with with plain-and-simple in order to guarantee integrity of the SQL file.</p> <p><strong>Download</strong><br /><a href="/downloads/dump_commit.sh.zip">dump_commit.sh.zip</a></p> <p><a href="/downloads/dump_commit_w_perms.sh.zip">dump_commit_w_perms.sh.zip</a> (dump and commit, plus update file permissions, a feature not related to backup - simply for maintenance reasons. I use this one myself, but use the other script if this feature is not wanted or needed)</p> </div></div></div><div class="field field-name-taxonomy-vocabulary-1 field-type-taxonomy-term-reference field-label-above"><div class="field-label">Categories:&nbsp;</div><div class="field-items"><div class="field-item even"><a href="/categories/drupal" typeof="skos:Concept" property="rdfs:label skos:prefLabel">Drupal</a></div><div class="field-item odd"><a href="/categories/mysql" typeof="skos:Concept" property="rdfs:label skos:prefLabel">MySQL</a></div><div class="field-item even"><a href="/categories/sysadmin" typeof="skos:Concept" property="rdfs:label skos:prefLabel">sysadmin</a></div><div class="field-item odd"><a href="/categories/svn" typeof="skos:Concept" property="rdfs:label skos:prefLabel">svn</a></div></div></div> Sat, 28 Mar 2009 17:28:46 +0000 Caleb Gilbert 87 at http://rocket.local http://rocket.local/blog/database-backup-dump-and-svn-commit-script-drupal-workflow#comments Speeding up svn / ssh transfer speed in terminal for Mac OS 10.5, Leopard http://rocket.local/blog/speeding-svn-ssh-transfer-speed-terminal-mac-os-105-leopard <div class="field field-name-body field-type-text-with-summary field-label-hidden"><div class="field-items"><div class="field-item even" property="content:encoded"><p>After struggling with upload/commit transfer speeds that were absolutely crippling, I've finally managed to get an exponential speed boost for svn merging and svn committing large numbers of files.</p> <p>For svn merging, see <a href="http://www.workhabit.org/subversion-merge-easy-way-copying-changes-trunk-prod-tag">this post by the good folks at WorkHabit.org</a>.</p> <p>For general SVN transfer speed help - hop into your /etc/ssh_config file and add these lines to your file:</p> <div class="codeblock"><code># Host *<br />Compression no<br />FallBackToRsh yes<br />KeepAlive yes</code></div> <p>Enjoy not seeing upload times of 2k/sec anymore. :-)</p> </div></div></div><div class="field field-name-taxonomy-vocabulary-1 field-type-taxonomy-term-reference field-label-above"><div class="field-label">Categories:&nbsp;</div><div class="field-items"><div class="field-item even"><a href="/categories/performance" typeof="skos:Concept" property="rdfs:label skos:prefLabel">performance</a></div><div class="field-item odd"><a href="/categories/ssh" typeof="skos:Concept" property="rdfs:label skos:prefLabel">ssh</a></div><div class="field-item even"><a href="/categories/svn" typeof="skos:Concept" property="rdfs:label skos:prefLabel">svn</a></div></div></div> Tue, 01 Jul 2008 22:23:24 +0000 Caleb Gilbert 76 at http://rocket.local http://rocket.local/blog/speeding-svn-ssh-transfer-speed-terminal-mac-os-105-leopard#comments