blob: 8dea2b2450ae079fd0ac99a4de8bdfa490af8c01 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
#!/bin/bash
# Backup a database *locally* to /backups/.
DB=$1
# Make our latest backup
/bin/mysqldump --user=root --add-drop-database $DB | /usr/bin/xz > /backups/$DB-$(date +%F).dump.xz
# link to the latest backup
ln -sf /backups/$DB-$(date +%F).dump.xz /backups/$DB-latest.xz
# Also, delete the backup from a few days ago.
rm -f /backups/$DB-$(date --date="3 days ago" +%F).dump.xz
|
