From fe5e4630e75a648f32a866b2b7a8dbffd1c25268 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期日, 13 九月 2026 15:35:40 +0800 Subject: [PATCH] docs: 部署说明补充数据库两条路线（空库4脚本/整套备份还原）与 init.sql 破坏性警告；备份已还原验证通过 --- docs/打包部署说明.md | 43 ++++++++++++++++++++++++++++++++++++------- 1 files changed, 36 insertions(+), 7 deletions(-) diff --git "a/docs/\346\211\223\345\214\205\351\203\250\347\275\262\350\257\264\346\230\216.md" "b/docs/\346\211\223\345\214\205\351\203\250\347\275\262\350\257\264\346\230\216.md" index 656d801..fd7b50c 100644 --- "a/docs/\346\211\223\345\214\205\351\203\250\347\275\262\350\257\264\346\230\216.md" +++ "b/docs/\346\211\223\345\214\205\351\203\250\347\275\262\350\257\264\346\230\216.md" @@ -69,17 +69,46 @@ ## 浜斻�佺洰鏍囨満鍣ㄩ儴缃叉楠� -### 5.1 鍒濆鍖栨暟鎹簱锛�4 涓剼鏈兘瑕佹墽琛岋級 +### 5.1 鍑嗗鏁版嵁搴擄紙涓ゆ潯璺嚎浜岄�変竴锛�**涓嶈娣风潃鍋�**锛� + +#### 璺嚎 A锛氬叏鏂扮┖搴擄紙瑕佽窇 4 涓剼鏈級 + +`init.sql` 鑷甫 `CREATE DATABASE` 涓� `USE traffic_audit`锛屽彲鐙珛鎵ц锛涘彟澶� 3 涓剼鏈病鏈� `USE` 璇彞锛屽繀椤荤敤 `-D traffic_audit`锛堟垨 `mysql ... traffic_audit < 鏂囦欢`锛夋寚瀹氬簱锛� ```bash -mysql --default-character-set=utf8mb4 -u root -p < db/init.sql -mysql --default-character-set=utf8mb4 -u root -p traffic_audit < db/sql_city_bus.sql -mysql --default-character-set=utf8mb4 -u root -p traffic_audit < db/sql_city_taxi.sql -mysql --default-character-set=utf8mb4 -u root -p traffic_audit < db/sql_wyc.sql +cd db +mysql --default-character-set=utf8mb4 -u root -p < init.sql # 寤哄簱 + 24 寮犲熀纭�琛� + 棰勭疆璐﹀彿 +mysql --default-character-set=utf8mb4 -u root -p -D traffic_audit < sql_city_bus.sql +mysql --default-character-set=utf8mb4 -u root -p -D traffic_audit < sql_city_taxi.sql +mysql --default-character-set=utf8mb4 -u root -p -D traffic_audit < sql_wyc.sql ``` -- 棰勭疆璐﹀彿锛歚admin / admin123`锛堢櫥褰曞悗璇风珛鍗虫敼瀵嗙爜锛夈�� -- 鎯宠繛鏁版嵁涓�璧锋惉锛氬湪婧愭満鍣� `mysqldump -u root -p --databases traffic_audit > traffic_audit_full.sql`锛屽湪鐩爣鏈哄櫒 `mysql -u root -p < traffic_audit_full.sql`锛堜細瑕嗙洊棰勭疆璐﹀彿锛夈�� +> 鈿狅笍 **`init.sql` 鏄牬鍧忔�х殑**锛氶噷闈㈢殑鍩虹琛ㄩ兘甯� `DROP TABLE IF EXISTS`銆�**宸叉湁鏁版嵁鐨勫簱涓婂崈涓囦笉瑕佸啀璺� init.sql**锛屽惁鍒欒〃鏁版嵁浼氳娓呯┖閲嶅缓銆� +> 4 涓剼鏈叡瑕嗙洊 29 寮犺〃锛坕nit.sql 24 寮� + 鍩庡競瀹㈣繍 3 寮� + 缃戠害杞� 2 寮狅級銆� + +#### 璺嚎 B锛氭妸鐜扮綉/寮�鍙戞満鐨勬暟鎹暣濂楁惉杩囧幓锛堟帹鑽愶紝涓嶇敤璺戣剼鏈級 + +鍦ㄦ簮鏈哄櫒锛堟湰鏈� MySQL 绔彛绀轰緥 3308锛屾寜瀹為檯鏀癸級锛� + +```bash +"D:\mysql\mysql-5.7.41-winx64\bin\mysqldump.exe" ^ + --host=127.0.0.1 --port=3308 --user=root --password=浣犵殑瀵嗙爜 ^ + --default-character-set=utf8mb4 --single-transaction --routines --triggers --events ^ + --databases traffic_audit > traffic_audit_full_YYYYMMDD.sql +``` + +鍦ㄧ洰鏍囨満鍣細 + +```bash +mysql --default-character-set=utf8mb4 -u root -p < traffic_audit_full_YYYYMMDD.sql +``` + +- `--databases` 浼氭妸 `CREATE DATABASE` + `USE` 涓�璧峰啓杩涘浠斤紝鎵�浠ョ洰鏍囨満鍣�**涓嶇敤鍏堝缓搴撱�佷篃涓嶇敤璺戦偅 4 涓剼鏈�**銆� +- 澶囦唤閲屽寘鍚� `sys_user`锛屾墍浠ヨ处鍙峰瘑鐮佷笌婧愭満鍣ㄥ畬鍏ㄤ竴鑷达紙鏈満鏄� `admin / 123456`锛夛紝涓嶄細琚� init.sql 閲嶇疆鎴� `admin/admin123`銆� +- 鐗堟湰鍏煎锛氭湰鏈烘槸 MySQL 5.7锛屽鍒� 5.7 鎴� 8.0 閮藉彲浠ワ紱鍙嶅悜锛�8.0 鈫� 5.7锛夊彲鑳藉洜 `utf8mb4_0900_ai_ci` 鎺掑簭瑙勫垯澶辫触銆� +- 鏈宸茬敓鎴愬苟楠岃瘉杩囧浠斤細`traffic_audit_full_20260913.sql`锛�45.5 MB锛�29 寮犺〃瀵煎叆鍚庨�愯〃 `COUNT(*)` 涓庢簮搴� 0 宸紓锛夈�� + +> 娉ㄦ剰锛歚docs/` 鐩綍锛堟姤琛ㄦā鏉裤�佹眹鎬诲ぇ琛ㄦ瘝鐗堬級**涓庢暟鎹簱鏃犲叧锛屾棤璁哄摢鏉¤矾绾块兘蹇呴』涓�骞舵嫹璐�**銆� ### 5.2 鏀归厤缃� `backend/application.yml` -- Gitblit v1.9.1