mariadb Backup Script

[root@appsrv /]# mkdir /shells

[root@appsrv /]# mkdir /root/mysqlbackup

[root@appsrv /]# nano /shells/mysqlbk.sh

#!/bin/bash

mysqldump --all-databases -uroot -pChinaskill21! > /root/mysqlbackup/all-database-$(date +"%Y%m%d%H%M%S")

三、编辑计划

[root@appsrv /]# nano /etc/crontab

*/30 * * * * root /shells/mysqlbk.sh

四、测试

[root@appsrv /]# mysqldump --all-databases -uroot -pChinaskill21! > /root/mysqlbackup/all-database-$(date +"%Y%m%d%H%M%S")

[root@appsrv /]# mysqldump --all-databases -uroot -pChinaskill21! > /root/mysqlbackup/all-database-$(date +"%Y%m%d%H%M%S")

[root@appsrv /]# ls /root/mysqlbackup

all-database-20220912005351 all-database-20220912005352