| | |
|---|
| | | #!/bin/bash |
|---|
| | | /usr/local/mysql/bin/mysqldump -h127.0.0.1 -uroot -pAtwl@2024 antaiwuliu > /usr/local/jars/dbbackup/antaiwuliu_$(date +%Y%m%d).sql |
|---|
| | | |
|---|
| | | # 删除7天前的备份数据 |
|---|
| | | find /usr/local/jars/dbbackup -name "antaiwuliu_*.sql" -type f -mtime +7 -exec rm {} \; > /dev/null 2>&1 |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | /usr/local/mysql/bin/mysqldump -h127.0.0.1 -uroot -pAtwl@2024 antaiwuliu > /usr/local/jars/dbbackup/antaiwuliu_0228JP.sql |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | # shellcheck disable=SC1036 |
|---|
| | | delete from platform_books where id not int (298,297,296,294,290,293) |
|---|
| | | |
|---|
| | | delete from platform_job a where not exist(select b.id from platform_books b where b.job_id=a.id and b.id in (298,297,296,294,290,293)) |
|---|
