MariaDB backup

• /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.