![[W10] W10 — mysqldump PHẢI dùng --single-transaction để không lock site](/web/image/blog.post/33/author_avatar/%5BW10%5D%20W10%20%E2%80%94%20mysqldump%20PH%E1%BA%A2I%20d%C3%B9ng%20--single-transaction%20%C4%91%E1%BB%83%20kh%C3%B4ng%20lock%20site?unique=ec8b089)
📌 MEDIUM |
Category: Web & IT |
ID: W10 |
Owner: CEO
W10 — mysqldump PHẢI dùng --single-transaction để không lock site
Tóm tắt
Backup WordPress DB mà không dùng--single-transaction → tables bị lock → site down trong khi backup.
Cách xử lý
mysqldump -u"$USER" -p"$PASS" \
--single-transaction --quick --lock-tables=false \
--default-character-set=utf8mb4 \
"$DB_NAME" | gzip -9 > backup.sql.gz
📚 Published from Company Knowledge Base — W10
Last updated: 2026-03-14
Review by: 2026-06-12