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