bash

Although bash is a powerful scripting environment it is a bit deficient, compare to other scripting languages, when it comes to date/time calculations. There are no convenient, generally available, date functions such as datediff or overloaded operators for mathematically manipulating dates and time.

Here is a simple backup script that we use to backup MySQL servers where there are a large number of databases. Each database is dumped out to separate file making restoration for individual databases much easier. Usually scripts dump all databases out into one large file. This is problematic if there are many databases and some of them are large. Simple copy the script into /etc/cron.daily to have it executed each day.