MariaDB backup: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 11: | Line 11: | ||
</pre> | </pre> | ||
* root's crontab: <pre> | * root's crontab: | ||
<pre> | |||
# Run mysql backup at 4:00 every day | # Run mysql backup at 4:00 every day | ||
0 4 * * * chronic /usr/local/sbin/mysql-backup | 0 4 * * * chronic /usr/local/sbin/mysql-backup | ||
Revision as of 17:25, 20 October 2022
/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