FREE BACKUP TOOL
While being a developer is mostly fun - there sure are things which are not all that enjoyable. While the task of backing up production databases is typically solved by system administrators I have found the need to be able to backup my local stuff as well.
Typically I have a LOT of MSSQL and MySQL databases lying on my box - and the number steadily grows as new versions of my systems are developed. Or it could be a client calling about a problem I can't reproduce - then I typically create a local copy of their database on my box and try to debug to see what's happening. So, fact: my number of databases are increasing and I don't feel like having to change the backu jobs to include new databases all the time.
More info on how I work: as a consultant I also use my USB harddisk a lot, it's a convinient way of getting data and code to and from my clients.
So with that background lets see how I wanted my backup solution
a) automatic tool to backup all databases (MySQL/MSSQL) - note ALL databases. The tools should retrieve all databases available. However a way to EXCLUDING certain databases from the backup would be suitable.
b) I want to back it up to my USB harddrive, and be able to store multiple versions. Possibly by creating a directory for each day I run it
c) sourcecode. Should work as specified in b) - but I would like to exclude temp files - such as .obj etc. Preferably I would like to be able to tell which type of project each directory is - for example C++, .NET, VB etc so trhe system would be able to backup the correct files