mysql backup

.database.cnf

[mysqldump]
host=localhost
user=user
password=password

backup.py

import datetime, os

today = str(datetime.datetime.today()).split(" ")[0]
backups = os.listdir("files")

def days_between(d1, d2):
  d1 = datetime.datetime.strptime(d1, "%Y-%m-%d")
  d2 = datetime.datetime.strptime(d2, "%Y-%m-%d")
  return abs((d2 - d1).days)

cmd = 'mysqldump --defaults-extra-file=".database.cnf" --all-databases --events > files/'+today+'.sql'

os.system(cmd)

for backup in backups:
  day = backup.replace(".sql", "")
  diff = days_between(day, today)
  if diff > 7:
    os.remove('files/'+backup)