Linux

Scripted MySQL Database Backups

In a perfect world you would be able to rely on the promise of automated systems to keep recent backups of your data. In many environments you are promised this functionality but it can sometimes fail. I wrote the mysql database backup script for those of us that sleep better at night with extra insurance.


#!/bin/bash

DB_BACKUP="home/cyberswat/db_dumps"
DB_USER="root"
DB_PASSWD="passwd"
DB_NAME="my_valuable_database"

### End of user editable variables ###

TIMESTAMP=`date +%Y-%m-%d-%H-%M-%S`

rm -rf /$DB_BACKUP/09
mv /$DB_BACKUP/08 /$DB_BACKUP/09

From Nothing to Everything with Ubuntu, Drupal, and Komodo Debugging

I've been using ActiveState's Komodo for a few weeks now in response to my frustrations with Eclipse. As with any IDE there was a short relearning of my ways that was necessary, but I am happy to report that I really like this IDE. The last bit of functionality I've been wanting to tie together is directly related to debugging Drupal in Komodo. Here's the steps that I took to get a Drupal development environment with debugging in Komodo on a clean installation of a 64bit Ubuntu 8.04.

A good deal of this may be redundant if you already have your environment established, but it is recorded here nonetheless to help others become proficient at what we do. While I prefer command line interfaces I am going to lean towards providing gui tools to allow newer devs options. If you don't need or want all of the minute details skip to step 6 and get straight into configuring for debugging.

Dev Friendly Apache Configuration for Drupal

I like to develop against local virtual hosts when I work with Drupal. Here is the apache httpd.conf configuration that has served me the best so far. The first VirtualHost is the default .. .simply replicate the second VirtualHost entry and edit accordingly. A simple edit of /etc/hosts to enter the virtual host name that matches the virtual host entries in the httpd.conf and a quick reload by apache and you are good to go. I particularly enjoy the independent logging for each site.

ssh passwordless login

  1. Generate a public/private key pair in your dev environment. Hit enter to accept the defaults. You will only ever need to run this once ... proceed to step two if you've already done this.
    $ ssh-keygen -t rsa
  2. Copy keys to remote server. Substitute server in the code below with your target machine.
    $ ssh server "mkdir ~/.ssh; chmod 0700 ~/.ssh"
    $ scp ~/.ssh/id_rsa.pub server:~/.ssh/authorized_keys2

How to Install Drupal using cPanel and MySQL

Heres a step by step tutorial on how to install Drupal 5.1 tailored for a standard LAMP (Linux, Apache, MySQL, PHP) setup. The servers I use for hosting have cPanel so these instructions are written to use it.

Gnome Random Wallpaper

Here's my first Python script.

Linux Gaming Extreme

I needed Ubuntu Linux, Nvidia and Wine to be able to fully leave Microsoft Windows and still play World Of Warcraft. I have a bit more than an average setup with 2 GeoForce 7800GTX SLI cards on an Asus A8N32-SLI Deluxe powered by a an AMD 64FX processor. I've been playing with different builds of Linux and various methods to get everything working, but nothing has impressed me or been easy until today. Here's an outline of every step taken to install Linux and start playing World of Warcraft. You can direct question to Slammer on the Undermine server ;-)

Yay ... no more windows

I've tried a few times to switch to Linux in the past with different levels of failure. I had to always switch back to Windows for one reason or the other. Most of the time it was because I needed to use Adobe Photoshop or wanted to play a game like World Of Warcraft. At the time, it seemed I would never be able to enjoy Linux as a desktop replacement.

I can finally announce that I, after 13 years as a developer, will never use Microsoft as the basis of a computing environment. I can now perform every task that I used a windows machine for on a Linux machine without a technical nightmare.

Syndicate content