How to realize regular backup of shell script by mysql

This article is about how mysql implements regular backup of shell scripts. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

#! / bin/bash

Echo "start backup"

Path='/backup/mysql/'

Paw='123456'

If [!-d "$path"]; then

Mkdir-p "$path"

Fi

# back up and log the backup

Xtrabackup-- backup--user=root-- host 172.30.249.57-- password $paw-- datadir=/data/DB/mysql-- target-dir=$path/backup-$ (date +% Y%m%d) > / backup/mysql/ `date +'% Y% m% d'` _ backup.log 2 > & 1

# Delete backups from 7 days ago

Find / backup/mysql-ctime + 7-exec rm-rf {}\

Echo "complete backup"

Then use crontab to execute it regularly.

0 4 * / root/mysql_backup.sh # executes at 4 am every morning

Thank you for reading! This is the end of this article on "how to achieve regular backup of shell scripts in mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!