2 tablespoons

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.

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.

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.

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.

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!