|
|
发表于 2024-3-23 13:53:10
|
显示全部楼层
写个脚本每分钟备份数据库就行
root@s32403 ~/backupwordpress # ls
backwordpress2024-03-09-22-33-51.sql backwordpress2024-03-17-23-20-01.sql
backwordpress2024-03-09-22-34-00.sql backwordpress2024-03-18-23-20-01.sql
backwordpress2024-03-09-23-06-55.sql backwordpress2024-03-19-23-20-01.sql
backwordpress2024-03-09-23-20-01.sql backwordpress2024-03-20-23-20-01.sql
backwordpress2024-03-10-23-20-01.sql backwordpress2024-03-21-23-20-01.sql
backwordpress2024-03-11-23-20-01.sql backwordpress2024-03-22-23-20-01.sql
backwordpress2024-03-12-23-20-01.sql backwordpress24-03-09-1709993476.sql
backwordpress2024-03-13-23-20-01.sql backwordpress24-03-09-1709993653.sql
backwordpress2024-03-14-23-20-01.sql backwordpress24-03-09-1709993659.sql
backwordpress2024-03-15-23-20-01.sql backwordpress24-03-09-1709993669.sql
backwordpress2024-03-16-23-20-01.sql mysql.sh
root@s32403 ~/backupwordpress # cat mysql.sh
#!/bin/bash
mysqldump -uroot -p12345678 --all-databases > ~/backupwordpress/backwordpress$(date +%F-%H-%M-%S).sql
|
|