Life in Manchester involves passing by some worrying signs. Here are a couple that I grabbed a picture of:

I am slightly confused by the upside-down car, but I’d say these figures are terrible news

This one speaks for itself

The hard-drive peripheral in for the Playstation 3 will run Linux. This news is by no means surprising as Sony’s direct opponent in the realm of home gaming is Microsoft. This news item, as usual, opens the door to common jokes (snippet from my post at Slashdot):

Who wouldn’t buy the Playstation 3, even just to play a game that no-one can resist: compiling the Linux kernel. That sure can keep one up until 5 AM.

…

Salesman: Here you see the latest Xbox which renders a zillion polygons per second.

Customer: Does it come with gcc?

Salesman: Is that one of the latest patches?

Customer: *sign* Not interested…

Ever wondered how popular your first name was? Is it becoming less common as the years go by? Or is it on the rise? It takes only 5 seconds to find out.

Firefox and Thunderbird do not integrate well under Linux. In order to associate the mailto protocol with Thunderbird, follow the steps below:

• Download this small shell script and put it somewhere sensible in your hard-drive
• Change line 3 to include the path of your thunderbird directory where it was initially installed, e.g.:
  export MOZILLA_FIVE_HOME="$HOME/Main/Programs/thunderbird"
• Open Firefox and enter the page about:config
• Add a new string; name it “”network.protocol-handler.app.mailto” and set its value to the full path of your new script, e.g. ~/scripts/tbmail.sh

Google are making significant changes to their ranking system. The changes have recently been entitled the Bourbon Update and a Google employee spread (leaked) the following information:

Here’s the advice that I’d give now: take a break from checking ranks for several more days. Bourbon includes something like 3.5 improvements in search quality, and I believe that only a couple are out so far. The 0.5 will go out in a day or so, and the last major change should roll out over the next week or so. Then there will still be some minor changes after that as well. So my “weather report” would be a recommendation that rankings may still change somewhat over the next several days.

Considering the date of this message, the search engine’s behaviour should have stabilised by now.

Google take their satellite maps service one step further:

…trucks would drive along every San Francisco street using the lasers to measure the dimensions of buildings, to create a 3D framework onto which digital photos can be mapped…

One wonders if they can acquire full-colour information. Perhaps their 2-D, top-down pictures can be mapped onto 3-D surfaces. We shall wait and see.

In other news, Google Maps have come under fire recently.

There are fast and automated ways of backing up *NIX servers. Backups should include databases as well as home directories, of which there can be many.

Compressed Archives

If backups can be downloaded via links (e.g. under cPanel), a browser can have its default action for .gz files set to “save in home directory”. A little script can then timestamp all the archives and put them ‘in storage’:

    # Once back-ups have been put in home directory, move all
    # to a time-stamped directory in the back-up area
cd /home/user/
mkdir `date +%Y-%m-%d`
mv backup* /home/user/backup/Home_Directories
    # move home directories
mv *.gz `date +%Y-%m-%d`
    # move databases to the new directory
cp -rf `date +%Y-%m-%d` /home/user/backup/Databases/Recent
    # merge if required
rm -r `date +%Y-%m-%d`
    # clean up, NOTE: mv cannot merge

FTP

If your webspace host offers FTP access alone, there is no simple solution. Command-line ftp might be of use though.

SCP

Copy files from the server to your local machine. This step must be invoked from the server’s side. The form of the command resembles the following:

scp -r ~/public_html your_user_name@machine.domain.suffix:/home/user/backup

mySQL Dumps

Set up cron jobs on the server, e.g.:

0 23 * * 1,4 mysqldump --user [DB_username] --password=[DB_password] [DB_name]> ~/tmp/mydatabase1.dump
0 23 * * 2,5 mysqldump --user [DB_username] --password=[DB_password] [DB_name]> ~/tmp/mydatabase2.dump
0 23 * * 0,3,6 mysqldump --user [DB_username] --password=[DB_password] [DB_name]> ~/tmp/mydatabase3.dump

The code above keeps a stack of 3 databases, which can be used to rollback data shall something catastrophic happen. Databases can then be snatched along with home directories. The above code can be extended so that dumps are compressed and file destinations are remote.