Dumps a mysql database daily at midnight (with day of the week rotation)

dump-db.sh

#!/bin/bash

_dow="$(date +'%A'|cut -c 1-3)"

# dumps the database with day of the week appended
mysqldump mydb -u db-user -p'password' > "/home/ubuntu/databases/database-demo-${_dow,,}.sql"

# copies last db dumped
cp "/home/ubuntu/databases/database-demo-${_dow,,}.sql" /home/ubuntu/database-demo.sql

cd /var/www/example/current/web

# publishes sql file
if [ ! -f "database-demo.sql" ]; then
  ln -s /home/ubuntu/database-demo.sql
fi