Cronjob backup of database

I’ve been working on ways to automatically backup the database for the website I’m currently developing (therapyhourstracker.com (set to be released in May or June 2010)).  After hunting around for useful ideas (including some great help from SHELLdorado) this is what I came up with:

mysqldump -u username -ppassword -h  www.databasehost.com --all-databases | gzip >  /home/user/backups/mysql_`date +"%Y-%m-%d"`.sql.gz
echo | mutt -a backups/mysql_`date +"%Y-%m-%d"`.sql.gz -- [email protected]

You’ll need to replace the generic names with your specifics (In the first line: username, password, www.databasehost.com with the login information for your mysql database.  /home/user/backups should become an existing directory on your server where you want to store the dumped files. In the second line backups/ should be the same directory on your server that you saved the dumped file to and [email protected] should be replaced with your email address).

The first line dumps and gzips the database into a file with today’s date in the name (line ends with the first ‘.sql.gz’ and a carriage return).  The second line uses mutt to send me an email with the dumped file as an attachment.

Doesn’t get much cooler than that.

Clipx: Great donationware clipboard manager

Just started using clipx and I love it.  If you have a task where you need to copy and paste a number of different text or image selections repetitively you need a copy of this program.  It stores your copies into a list and you can paste from any one of the items in the list whenever you want.  The best thing is that it seems to be stable.  I’ve used a couple other programs that are supposed to do this but they have been very unweildy.

It’s donationware so send them some beer money if it’s useful to you.

Slick shell Script for automatically svn adding and deleting files

I’m working on a job that recently required adding a large number of new animated banners to the filestructure as part of an update.  Scoured the web for a good trick and BANG, found it.  This script comes from Kathleen Murtagh’s blog with a slight edit from one of her readers, perusio.

#!/bin/bash
svn status | grep '^?' | sed -e 's/^? /svn add "/g' -e 's/$/"/g' | sh
svn status | grep '^!' | sed -e 's/^! /svn delete "/g' -e 's/$/"/g' | sh

Truly a timesaver.

The 9+1 Best TED Talks Ever

I keep finding more that I love (keep ’em coming TED) so I’m just adding to the original list.  Nothing but the best:

If you’re like me and are inspired by scientific and technological advances and bleeding-edge knowledge of our universe and human-kind, you will love ted.com. Whenever I’m unimpressed with the world and its inhabitants (especially myself) I go to ted.com, and it always manages to impress me. TED reminds me that anything is possible if we can dream it and commit to making it real.

TED.com has hundreds of free videos featuring innovative speakers from each field. Almost all the talks are fascinating–even if the subject matter doesn’t interest me I usually can’t help but be drawn in by the speaker’s passion.

Here are the ten best talks:

  • The Human Brain
    • NEW:  Robert Sapolsky, a primatologist, gives an insightful, provocative, funny, impressive talk to Stanford graduates.  He focuses on the unexpected areas where humans are just like other animals, and even more unexpected areas where we’re one of the unique-e-er species on the planet.  Wonderful.
    • Jill Bolte Taylor is a brain researcher who suffered a massive stroke. She describes what it was like to be conscious during the stroke, watching parts of her brain shut down. Truly amazing.
    • Jeff Hawkins (developer of the Palm and Treo) talks about brain Continue reading