On the production Wikilink server we set up weekly database backups. These were done via a simple script which was never added to the repository:

#!/bin/bash

now="$(date +'%d%m%Y')"

mysqldump -h"127.0.0.1" -u"root" -p"[password]" extlinks_db > /home/samwalton9/db_backup/${now}_backup.sql

/home/samwalton9/db_backup/ was a bad location to put these, and we had no retention schedule so the instance kept filling its disk space.

We should implement a better weekly backup system, and delete old backups after 3 months.

Acceptance criteria

• Each week a database backup should be taken
• Backups should be deleted 3 months after their creation