From 69a1b3bf45738f048361ee4ccb6bdc64fce35720 Mon Sep 17 00:00:00 2001
From: MrShi <1878285526@qq.com>
Date: 星期三, 12 三月 2025 11:31:46 +0800
Subject: [PATCH] 更新
---
server/startsh/DBbackup.sh | 16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/server/startsh/DBbackup.sh b/server/startsh/DBbackup.sh
new file mode 100644
index 0000000..ad06f55
--- /dev/null
+++ b/server/startsh/DBbackup.sh
@@ -0,0 +1,16 @@
+#!/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
+
+
+
+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))
--
Gitblit v1.9.3