This site is to keep me up to date with myself, but you're welcome to follow along. Next time I go on a tangent, you may want to come with...
I wanted to most-simply make a CSV import-seeded array in a Drupal themed table for a preview. Then I was like, "Hey could I include the CSV line number (the array index) as the first column in the table preview?" Here's what I came up with:
From the annals of "and exactly how did I for from Drupal develoer and site builder to server admin" comes this tale of a weekend gone to rot.
Short story: Looks like our MySQL binary log files are filling up and rotating out as they've been configured to do (1.1GB apiece), but our not particularly large nor heavily trafficked Drupal 7 site binlogs were rotating out ~10/day! Do the math-- that's .. a big number of gigglebytes gone down the tube in a heartbeat!
Drush .. scripts? Like shell scripts?
What you're looking for is this drush command:
drush topic docs-scripts
I was really hoping to find something at the top of my search results for getting started with drush scripting, but alas, nada. I did come across a d.o issue thread between greg and moshe where I guess drush shebang scripting was first introduced. I love this community!
On an inherited project, firing up a new dev site in Pantheon, I have it in mind that I need to provide the Drupal mysql dump without the table prefixes this shared host user currently has.
drush sql-dump > ~/migrate/site.sql
sed -i 's/theprefix//g' ~/migrate/site.sql
Hope this works. I mean, I hope this helps.
For something a little different, I thought I'd post about one of the fringe benefits of moving.
I hate moving, it's expensive, and it's wasteful. However, a year later when we finally got around to emtpying one of the larger moving boxes (a cardboard, wardrobe box read: very tall, sturdy, and wasteful), the kids took to it immediately. Together, we splashed on a coat of blue tempra paint, and voila, a homemade TARDIS for the kids to enjoy! :D
Moving boxes make great toys and a super time machine!