Blogs

Restore individual MySQL records with SELECT INTO OUTFILE and LOAD DATA INFILE

Submitted by chad on Sun, 06/24/2012 - 20:24

Every now and then, a single CMS post may vanish or a forum user's posts are accidentally deleted. No worries, right? That's why we make backups. If you have an active site with lots of users posting content, loading a backup is probably not practical. So, load up the latest incremental backup and select the records you need, and do it easily with MySQL's SELECT INTO OUTFILE and LOAD DATA INFILE.

Connect to MS SQL Server and Sybase ASE from Mac OS X and Linux with unixODBC and FreeTDS

Submitted by chad on Fri, 06/08/2012 - 12:12

Although I haven't had need to do so for freelance jobs, I do administer several Windows-based Sybase and MS SQL Servers at my day job.

Tutorial: Getting started with localization and translation in Drupal 7, by example

Submitted by chad on Wed, 11/23/2011 - 13:23

I'm beginning to build a Drupal-powered web site for a customer. A goal for this project is to provide translation of pages, events, and announcements for Spanish-speaking site visitors. Although Google's Translation service is great, automated translation tools remain less than perfect. Fortunately, the customer has several dedicated bilingual volunteers who will translate as much of the site's content as possible.

An Introduction to Drupal's Command Line Interface, Drush

Submitted by chad on Sun, 07/03/2011 - 21:31

I previously wrote about a couple of bash scripts I wrote to manage Drupal core and module updates via SVN. While those scripts handle the basics pretty well, I realized that I needed to get to know Drush. I have a few Drupal upgrade project's coming up, so I spent the past few days getting familiar with Drush. Here's what I've learned so far.

Twitter Module for Gallery 3: Share Your Photos, Movies, and Albums with your Followers

Submitted by chad on Thu, 05/19/2011 - 08:59

I've just packaged and posted the final 1.0 release of a Twitter module for Gallery 3. Share photos, movies, and albums with your Twitter followers, directly from Gallery. Give it a try!