I’ve been gunzipping my MySQL dumps before importing them.  This was always mildly annoying – especially when working on Drupal projects where the database seems to get passed around a lot. Today I found a more concise approach: use gzcat to read the contents of the gzipped file directly into your database like this: gzcat...

We’re working on the new blenderbox site, and we’re moving from SQL server to a MySQL server and I wanted to quickly move our project data from our old server to the new one. I came across a great way to import data into a MySQL database directly from a CSV file. Firstly, you’ll need...

I took the release of Snow Leopard as an opportunity to do a clean wipe and re-install of Leopard and Snow Leopard. As usual, Dan Benjamin has a great series of articles on getting the latest and greatest setup. I aggregated these articles into a bash script to automate installing MySQL, Ruby, Rails, RubyGems and...