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

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.

Filed under

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

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.

Filed under

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

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.

Filed under

An Introduction to Drupal's Command Line Interface, Drush

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.

Filed under

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

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!