MariaDB backup

From Notes to self

Revision as of 17:21, 30 March 2023 by Verbovet (talk | contribs)

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

Jump to navigation Jump to search

/usr/local/mysqlbackups/mysql-backup

#!/bin/bash

cd /usr/local/mysqlbackups/

/usr/bin/mariabackup --user=root --backup --stream=xbstream \
    | gzip > backup.xb.gz || exit 1

mv backup.xb.gz backup-$(date '+%Y-%m-%d_%H-%M').xb.gz

\ls backup-*_*.xb.gz | head -n -10 | xargs -r rm

/etc/cron.hourly/mysql-backup

#!/bin/bash
exec chronic /usr/local/mysqlbackups/mysql-backup

To restore full backup:

# mkdir /root/backupdb
# gunzip -c /usr/local/mysqlbackups/backup-XXXXXXXX.xb.gz | mbstream -x -C /root/backupdb
# mariabackup --prepare --target-dir=/root/backupdb
Ensure that the datadir (/var/lib/mysql) is empty
# /etc/rc.d/rc.mysqld stop
# mariabackup --copy-back --target-dir=/root/backupdb
# chown -R mysql:mysql /var/lib/mysql
# /etc/rc.d/rc.mysqld start

To restore a single database, see here.

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

Linux