Main menu

Slide Scanning

My CanoScan FS4000US has broken down for the second time and I am thinking of scrapping it. Unfortunately new, high-resolution slide scanners are very expensive, so I will first try some of the slide scanning services.

Google search for "slide scanning service" yields these (and several thousand more):

Emailing backup file

The bash script I wrote worked well, stepping through and backing up the 9 individual databases to a temporary directory, then archiving that directory. Unfortunately, the desired next step of emailing that file turned out to be an issue. The version of mail on the host company's computer did not handle attachments and building the mime headers and converting the file to 7-bit seemed like a pain, so I thought I would do a little Python scripting. Unfortunately, the story there was the same -- the appropriate python email modules weren't there either.


Backing Up MySQL

I have 9 databases in MySQL that need to be backed up, so I wrote a bash script that:

  1. Creates folder /backups/SQL_BACK-yymmdd
  2. For each of the databases, uses mysqldump to generate a backup file (in the above folder) named dbname-yymmdd.sql.
  3. After completing for all the databases, then generates a tar.gz of the folder. The compressed file is named /backups/SQL_BACK-yymmdd.tar.gz

The uncompressed files total around 100 MB while the compressed file is only about 19 MB.

The bash script runs under cron at around 10:30pm.

Initial Setup

I used Softaculous for a quick clean install of D7. A simple copy from backup of various directories (gallery, images, sites) plus the .htaccess file allowed quick setup of the gallery (unharmed in my database debacle) and the site banner image.

Overnight, a bunch of jerks tried setting up logins for the site, but they were blocked awaiting Admin approval. This morning I deleted them all, changed settings so only Admin may add users and eliminated the login block in the left sidebar.

Next I will set up a couple of views and some menu items.


Rebuilding the Site

A few weeks ago I taught myself another lesson on the need for backups when I deleted the MySQL database behind this site. No backup, no database, no site.

So, in parallel with rebuilding the site, I am also writing a set of cron routines that will use mysqldump to make scheduled copies of all the databases. Then I can download these for offsite copies.



D7 Upgrade - 4/23/11

Very frustrating day.

Followed the Upgrade.txt steps, but when finally at step 13, visit upgrade.php, I got the error message:

"Drupal 7 requires PHP 5.2.4 or higher with the PHP Data Objects (PDO) extension enabled."

Round and round. Checked the host site to make sure php and PDO were there. php -i reported php 5.2.13 and PDO extensions for mysql working. Googled all over but got nothing but dead ends. Changed the connection info to look like D7 settings.php, but that did nothing.

D7 Upgrade - 4/22/11

I made slow progress today, mostly because of my unfamiliarity with the tools greengeeks (my web host) gave me.

Upgrade to drupal 7

Drupal 7 came out months ago. I've been waiting to see if any issues came up, but I think I've waited long enough.

Drupal 7 comes with a detailed Upgrade.txt file plus lots of online documentation to supplement it. That said, it looks like there will be a fair amount to consider, so I will start with this rather simple blog. After getting my feet wet with this site, I can then start to work through the much more complex site for

New iPad2

I got an iPad2 a couple of weeks ago and have been using it pretty heavily both at home and at work, looking for any limitations. So far, they are pretty few and far between.

The iPad is an excellent communicator. Safari is a fine browser, though the lack of flash is something of a nuisance (can't apple's tech wizards figure out how to make flash play in a sandbox?). Bookmarking works, albeit differently than on my MacBook.


Using GreenGeeks Web Hosting

I signed last evening up with GreenGeeks web hosting to handle my various websites.

Several things pushed me away from self-hosting:


Drupal theme by D7 ver.1.1