After taking over a server that had been through a few (very) different system administrators I had to write the MySQL backup all over again.

This resulted in a nice little script that does backup pr. database, compresses it with 7zip and has detailed log of the event.