MariaDB backup

From Notes to self

Revision as of 17:14, 20 October 2022 by Verbovet (talk | contribs) (Created page with "* <code>/usr/local/sbin/mysql-backup</code> <pre> #!/bin/bash TS=$(date '+%Y%m%d') /usr/bin/mariabackup --user=root --backup --stream=xbstream \ | gzip > /usr/local/mysql...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

Retrieved from "https://alik.ejik.org/index.php?title=MariaDB_backup&oldid=2362"

Linux