MariaDB backup

From Notes to self
Revision as of 17:25, 20 October 2022 by Verbovet (talk | contribs)
Jump to navigation Jump to search
  • /usr/local/sbin/mysql-backup
#!/bin/bash

TS=$(date '+%Y%m%d')
/usr/bin/mariabackup --user=root --backup --stream=xbstream \
    | gzip > /usr/local/mysqlbackups/backup-$TS.xb.gz || exit 1

TS=$(date -d "10 days ago" '+%Y%m%d')
rm -f /usr/local/mysqlbackups/backup-$TS.xb.gz
  • root's crontab:
# Run mysql backup at 4:00 every day
0 4 * * * chronic /usr/local/sbin/mysql-backup
Retrieved from "https://alik.ejik.org/index.php?title=MariaDB_backup&oldid=2364"