Since I wrote this article I added a followup article fixing a small problem with this script. Read the article below first though!

This tutorial is really most of all a reminder for me, and some of my friends who use Site5 hosting. It has a few flaws which I will get back to in the end. This site is intended for small sites, like Wordpress blogs, running on shared hosts. The main idea is this: backup all the data of your website daily, automatically, to an offsite location.

Step 1: Get Access to a Subversion Repository

The great thing about Subversion is that it offers incremental backups, allowing you to go back in time as far as you need to restore any problems you might run into. Assembla.com offers free subversion hosting (besides all the other things they offer), which is virtually unlimited. They do charge corporations, but with my current use (4 sites doing a daily backup) I haven’t had any problem with them contacting me or something.

Simply sign up and set up a “Space”. Ignore most of the settings but make sure to setup a Trac+Subversion package for your space. This will enable Trac support and subversion. Once the site is setup, go into the Trac/SVN tab and check the Subversion URL. It should be something like this:

http://svn2.assembla.com/svn/<your_site_name>
(more…)

• ATP Photo Finder - Quite a good GeoTagging solution
  This is seriously becoming something i would love to use. Best GeoTagging solution so far. No software needed and compatible with virtually every camera.
  (tags: photography gps geotagging gadgets photo hardware tagging)
• How to backup and import a MySQL InnoDB database
  I am trying to automate some backup features on my webservers. For now this tutorial has given me a decent backup solution.
  (tags: Mysql Backup innodb database SQL mysqldump db)

• Building a .com in 24 hours
  interesting website on how to build a .com in 24 hours. lots of tips and tricks
  (tags: development programming startup webdesign howto business rails)

A while back I posted a video of my BarcampLondon3 presentation created by Tom Morris. Lucky for me Improbulus took a bit of a better video (which also shows the screen we are all looking at). If anybody is interested in seeing this again, enjoy!

I was having a very interesting talk with Ian and Glyn yesterday during dinner about the DataPortability workgroup. I can start explaining what the idea of data portability is, but I think that this next video explains way more. Let me just say that Google, Facebook and Plaxo recently joined for a good reason.

(more…)