{"id":994,"date":"2025-11-25T13:51:36","date_gmt":"2025-11-25T05:51:36","guid":{"rendered":"http:\/\/www.preluna.xyz\/?p=994"},"modified":"2025-11-27T15:18:55","modified_gmt":"2025-11-27T07:18:55","slug":"n8nwithwordpress","status":"publish","type":"post","link":"http:\/\/www.preluna.xyz\/index.php\/2025\/11\/25\/n8nwithwordpress\/preluna\/technology\/career-skills\/tech-writing\/","title":{"rendered":"n8n\u4e0e\u7f51\u9875\u63d0\u53d6"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u521b\u5efa Docker Compose \u6587\u4ef6<\/h2>\n\n\n\n<p>\u9996\u5148\uff0c\u4f60\u9700\u8981\u521b\u5efa\u5e76\u7f16\u8f91&nbsp;docker-compose.yml&nbsp;\u6587\u4ef6\u3002<\/p>\n\n\n\n<p><strong>\u8fdb\u5165\u9879\u76ee\u76ee\u5f55<\/strong>\uff1a\u5982\u679c\u8fd8\u6ca1\u8fdb\u5165\u4f60\u4e4b\u524d\u521b\u5efa\u7684&nbsp;n8n-article-system&nbsp;\u76ee\u5f55\uff0c\u5148\u5bfc\u822a\u8fc7\u53bb\u3002<\/p>\n\n\n\n<p><strong><em>bash:<\/em><\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd ~\/n8n-article-system<\/code><\/pre>\n\n\n\n<p><strong>\u521b\u5efa\u5e76\u7f16\u8f91\u6587\u4ef6<\/strong>\uff1a\u5728 Linux \u4e2d\uff0c\u6211\u4eec\u901a\u5e38\u4f7f\u7528\u547d\u4ee4\u884c\u6587\u672c\u7f16\u8f91\u5668\uff08\u5982&nbsp;nano\uff09\u6765\u521b\u5efa\u548c\u7f16\u8f91\u6587\u4ef6\u3002\u5b83\u7684\u64cd\u4f5c\u6bd4\u8f83\u7b80\u5355\uff0c\u9002\u5408\u65b0\u624b\u3002<\/p>\n\n\n\n<p><strong><em>bash:<\/em><\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>nano docker-compose.yml<\/code><\/pre>\n\n\n\n<p><strong>\u590d\u5236\u5e76\u7c98\u8d34\u914d\u7f6e\u5185\u5bb9\uff1a<\/strong>\u5c06\u4e0b\u9762\u8fd9\u6bb5\u5b8c\u6574\u7684 docker-compose.yml \u914d\u7f6e\u5185\u5bb9\u590d\u5236\uff0c\u7136\u540e\u56de\u5230 Ubuntu \u547d\u4ee4\u884c\u7a97\u53e3\uff0c\u53f3\u952e\u70b9\u51fb\u9f20\u6807\u7c98\u8d34\u5230 nano \u7f16\u8f91\u5668\u4e2d\u3002<\/p>\n\n\n\n<p><strong><em>yml:<\/em><\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>services:\n  n8n:\n    image: n8nio\/n8n:latest\n    container_name: n8n-article-system\n    restart: unless-stopped\n    ports:\n      - \"5678:5678\"\n    environment:\n      - N8N_DEFAULT_BINARY_DATA_MODE=filesystem\n      - DB_SQLITE_DATABASE=\/home\/node\/.n8n\/database\/n8n.sqlite\n      - TZ=Asia\/Shanghai\n    volumes:\n      - .\/database:\/home\/node\/.n8n\/database\n      - .\/articles:\/home\/node\/.n8n\/articles<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d61-1024x325.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"325\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d61-1024x325.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-995\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p><strong>\u6ce8\uff1a<\/strong>\u8fd9\u91cc\u7684<em><strong> N8N_ENCRYPTION_KEY<\/strong><\/em> \u7528\u4e8e\u52a0\u5bc6\u654f\u611f\u4fe1\u606f\uff0c\u5728\u751f\u4ea7\u73af\u5883\u4e2d\u52a1\u5fc5\u5c06\u5176\u4fee\u6539\u4e3a\u590d\u6742\u7684\u968f\u673a\u5b57\u7b26\u4e32<\/p>\n\n\n\n<p><strong>\u4fdd\u5b58\u5e76\u9000\u51fa nano \u7f16\u8f91\u5668\uff1a<\/strong>\u6ce8\u610f\u9700\u8981\u628a\u5149\u6807\u79fb\u5230\u5230\u6700\u540e\u4e00\u884c\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6309\u4e0b&nbsp;<code>Ctrl + O<\/code>&nbsp;(Write Out) \u6765\u4fdd\u5b58\u6587\u4ef6\uff0c\u6309&nbsp;<strong>Enter<\/strong>&nbsp;\u786e\u8ba4\u6587\u4ef6\u540d\u3002<\/li>\n\n\n\n<li>\u6309\u4e0b&nbsp;<code>Ctrl + X<\/code>&nbsp;\u9000\u51fa\u7f16\u8f91\u5668\u3002<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u542f\u52a8\u4e0e\u7ba1\u7406\u5bb9\u5668<\/h2>\n\n\n\n<p>\u914d\u7f6e\u6587\u4ef6\u51c6\u5907\u597d\u540e\uff0c\u542f\u52a8\u548c\u7ba1\u7406\u5bb9\u5668\u5c31\u5f88\u7b80\u5355\u4e86<\/p>\n\n\n\n<p>1.<strong>\u542f\u52a8\u5bb9\u5668\uff1a<\/strong>\u5728 docker-compose.yml \u6587\u4ef6\u6240\u5728\u76ee\u5f55\uff0c\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u6765\u542f\u52a8\u670d\u52a1\u3002-d \u53c2\u6570\u8868\u793a\u5728\u540e\u53f0\u8fd0\u884c<\/p>\n\n\n\n<p><strong><em>bash:<\/em><\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker-compose up -d<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d62-1024x161.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"161\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d62-1024x161.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-996\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>\u9996\u6b21\u8fd0\u884c\u4f1a\u4ece Docker Hub \u4e0b\u8f7d n8n \u955c\u50cf\uff0c\u9700\u8981\u4e00\u70b9\u65f6\u95f4\u3002<\/p>\n\n\n\n<p>2.<strong>\u68c0\u67e5\u5bb9\u5668\u72b6\u6001<\/strong>\uff1a\u542f\u52a8\u540e\uff0c\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u786e\u8ba4\u5bb9\u5668\u662f\u5426\u6b63\u5e38\u8fd0\u884c<a href=\"https:\/\/labex.io\/zh\/tutorials\/docker-essential-docker-compose-commands-for-container-management-398434\" target=\"_blank\" rel=\"noreferrer noopener\"><\/a>\u3002<\/p>\n\n\n\n<p><strong><em>bash:<\/em><\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker-compose ps<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d63-1024x325.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"325\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d63-1024x325.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-997\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>\u5982\u679c\u72b6\u6001 (State) \u663e\u793a\u4e3a Up\uff0c\u5c31\u8bf4\u660e\u5bb9\u5668\u542f\u52a8\u6210\u529f\u4e86\u3002<\/p>\n\n\n\n<p>3.<strong>\u67e5\u770b\u5b9e\u65f6\u65e5\u5fd7<\/strong>\uff1a\u5982\u679c\u60f3\u67e5\u770b\u5bb9\u5668\u7684\u65e5\u5fd7\u8f93\u51fa\uff0c\u53ef\u4ee5\u4f7f\u7528\uff1a<\/p>\n\n\n\n<p><em><strong>bash:<\/strong><\/em><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker-compose logs -f<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d64-1024x325.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"325\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d64-1024x325.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-998\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>\u6309&nbsp;<code>Ctrl + C<\/code>&nbsp;\u53ef\u4ee5\u9000\u51fa\u65e5\u5fd7\u67e5\u770b\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5e38\u7528\u7684\u5bb9\u5668\u7ba1\u7406\u547d\u4ee4<\/h2>\n\n\n\n<p>\u638c\u63e1\u4ee5\u4e0b\u51e0\u4e2a\u547d\u4ee4\uff0c\u4f60\u5c31\u80fd\u8f7b\u677e\u7ba1\u7406\u8fd9\u4e2a\u5bb9\u5668\u4e86\uff1a<\/p>\n\n\n\n<p><strong>\u505c\u6b62\u670d\u52a1<\/strong>\uff1a\u8fd9\u4f1a\u505c\u6b62\u5bb9\u5668\uff0c\u4f46\u4e0d\u4f1a\u5220\u9664\u5b83\u4eec<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker-compose stop<\/code><\/pre>\n\n\n\n<p><strong>\u91cd\u65b0\u542f\u52a8\u670d\u52a1<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker-compose restart<\/code><\/pre>\n\n\n\n<p><strong>\u505c\u6b62\u5e76\u5220\u9664\u5bb9\u5668<\/strong>\uff1a\u5982\u679c\u4f60\u60f3\u5f7b\u5e95\u505c\u6b62\u5e76\u79fb\u9664\u5bb9\u5668\u3001\u7f51\u7edc\u7b49\u8d44\u6e90\uff0c\u53ef\u4ee5\u4f7f\u7528<a href=\"https:\/\/labex.io\/zh\/tutorials\/docker-essential-docker-compose-commands-for-container-management-398434\" target=\"_blank\" rel=\"noreferrer noopener\"><\/a>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker-compose down<\/code><\/pre>\n\n\n\n<p>\u4e0b\u6b21\u542f\u52a8\u65f6\uff0c\u518d\u6b21\u8fd0\u884c docker-compose up -d \u5373\u53ef\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u8bbf\u95ee\u670d\u52a1\u4e0e\u6587\u4ef6<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u8bbf\u95ee n8n \u7f51\u9875\u754c\u9762<\/strong>\uff1a\u5bb9\u5668\u542f\u52a8\u540e\uff0c\u4f60\u53ef\u4ee5\u5728\u5bbf\u4e3b\u673a\uff08Ubuntu\uff09\u7684\u6d4f\u89c8\u5668\u4e2d\u8bbf\u95ee&nbsp;http:\/\/localhost:5678&nbsp;\u6765\u4f7f\u7528 n8n\u3002\u5982\u679c\u4f60\u7684 Ubuntu \u662f\u7eaf\u547d\u4ee4\u884c\u7248\u672c\u6ca1\u6709\u684c\u9762\u73af\u5883\uff0c\u90a3\u4e48\u4f60\u53ef\u80fd\u9700\u8981\u901a\u8fc7\u7f51\u7edc IP \u6765\u8bbf\u95ee\uff0c\u6216\u8005\u6682\u65f6\u8df3\u8fc7\u8fd9\u4e00\u6b65\uff0c\u4e13\u6ce8\u4e8e\u6211\u4eec\u4e4b\u524d\u8ba8\u8bba\u7684\u6587\u7ae0\u6293\u53d6\u5de5\u4f5c\u6d41\u7684\u642d\u5efa\uff08\u8fd9\u4e9b\u4e5f\u53ef\u4ee5\u5728\u547d\u4ee4\u884c\u754c\u9762\u8fdb\u884c\u914d\u7f6e\u548c\u7ba1\u7406\uff09\u3002<\/li>\n\n\n\n<li><strong>\u627e\u5230\u4f60\u751f\u6210\u7684\u6587\u4ef6<\/strong>\uff1a\u6839\u636e&nbsp;<strong><em>docker-compose.ym<\/em><\/strong><em><strong>l<\/strong><\/em>&nbsp;\u4e2d\u7684\u914d\u7f6e\uff0c\u6240\u6709\u7531 n8n \u5de5\u4f5c\u6d41\u751f\u6210\u7684\u6587\u7ae0 Markdown \u6587\u4ef6\u90fd\u4f1a\u4fdd\u5b58\u5728&nbsp;<strong><em>~\/n8n-article-system\/articles\/<\/em><\/strong>&nbsp;\u76ee\u5f55\u4e0b\u3002\u4f60\u53ef\u4ee5\u5728 Ubuntu \u547d\u4ee4\u884c\u4e2d\u4f7f\u7528&nbsp;<strong><em>ls ~\/n8n-article-system\/articles\/&nbsp;<\/em><\/strong>\u547d\u4ee4\u6765\u67e5\u770b\u8fd9\u4e9b\u6587\u4ef6\u3002<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u989d\u5916\u914d\u7f6e<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u914d\u7f6e\u5907\u4efd\u7b56\u7565<\/strong><\/h3>\n\n\n\n<p>\u5728&nbsp;<code>~<\/code>\/n8n-article-system\/&nbsp;\u76ee\u5f55\u4e0b\u521b\u5efa&nbsp;backup.sh\uff1a(\u81ea\u52a8\u5907\u4efd\u811a\u672c)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>nano backup.sh<\/code><\/pre>\n\n\n\n<p><strong>\u5185\u5bb9\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\n# \u5907\u4efd\u811a\u672c - \u8bf7\u5c06 \/home\/wang \u66ff\u6362\u4e3a\u4f60\u7684\u5b9e\u9645home\u8def\u5f84\n\nBACKUP_DIR=\"\/home\/wang\/n8n-article-system\/backups\/$(date +%Y%m%d_%H%M%S)\"\necho \"\ud83d\udce6 \u521b\u5efa\u5907\u4efd: $BACKUP_DIR\"\n\nmkdir -p \"$BACKUP_DIR\"\n\n# \u5907\u4efd\u6570\u636e\u5e93\nif &#91; -d \"\/home\/wang\/n8n-article-system\/database\" ]; then\n    cp -r \/home\/wang\/n8n-article-system\/database \"$BACKUP_DIR\/\" 2&gt;\/dev\/null \n    echo \"\u2705 \u6570\u636e\u5e93\u5907\u4efd\u5b8c\u6210\"\nelse\n    echo \"\u26a0\ufe0f  \u6570\u636e\u5e93\u76ee\u5f55\u4e0d\u5b58\u5728\uff0c\u8df3\u8fc7\u5907\u4efd\"\nfi\n\n# \u5907\u4efd\u6587\u7ae0\nif &#91; -d \"\/home\/wang\/n8n-article-system\/articles\" ]; then\n    cp -r \/home\/wang\/n8n-article-system\/articles \"$BACKUP_DIR\/\" 2&gt;\/dev\/null\n    echo \"\u2705 \u6587\u7ae0\u5907\u4efd\u5b8c\u6210\"\nelse\n    echo \"\u26a0\ufe0f  \u6587\u7ae0\u76ee\u5f55\u4e0d\u5b58\u5728\uff0c\u8df3\u8fc7\u5907\u4efd\"\nfi\n\n# \u5907\u4efd\u914d\u7f6e\nif &#91; -d \"\/home\/wang\/n8n-article-system\/config\" ]; then\n    cp -r \/home\/wang\/n8n-article-system\/config \"$BACKUP_DIR\/\" 2&gt;\/dev\/null\n    echo \"\u2705 \u914d\u7f6e\u5907\u4efd\u5b8c\u6210\"\nelse\n    echo \"\u26a0\ufe0f  \u914d\u7f6e\u76ee\u5f55\u4e0d\u5b58\u5728\uff0c\u8df3\u8fc7\u5907\u4efd\"\nfi\n\n# \u521b\u5efa\u538b\u7f29\u5305\ntar -czf \"$BACKUP_DIR.tar.gz\" \"$BACKUP_DIR\" 2&gt;\/dev\/null\nrm -rf \"$BACKUP_DIR\"\n\necho \"\ud83c\udf89 \u5907\u4efd\u5b8c\u6210: $BACKUP_DIR.tar.gz\"\necho \"\ud83d\udcc1 \u5907\u4efd\u4f4d\u7f6e: \/home\/wang\/n8n-article-system\/backups\/\"<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d65.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1019\" height=\"623\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d65.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-999\"  sizes=\"auto, (max-width: 1019px) 100vw, 1019px\" \/><\/div><\/figure>\n\n\n\n<p><strong>\u7ed9\u811a\u672c\u6267\u884c\u6743\u9650\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>chmod +x backup.sh<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u914d\u7f6e\u65e5\u5fd7\u8f6e\u8f6c<\/strong><\/h3>\n\n\n\n<p>\u540c\u6837\u5728&nbsp;~\/n8n-article-system\/&nbsp;\u76ee\u5f55\u4e0b\u521b\u5efa&nbsp;log-rotate.sh:<\/p>\n\n\n\n<p><strong>\u521b\u5efa\u65e5\u5fd7\u7ba1\u7406\u914d\u7f6e\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u68c0\u67e5\u65e5\u5fd7\u6587\u4ef6\u5927\u5c0f\ndu -sh logs\/\n\n# \u5982\u679c\u65e5\u5fd7\u592a\u5927\uff0c\u53ef\u4ee5\u914d\u7f6e\u65e5\u5fd7\u8f6e\u8f6c\nnano log-rotate.sh<\/code><\/pre>\n\n\n\n<p><strong>\u5185\u5bb9\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\n# \u65e5\u5fd7\u8f6e\u8f6c\u811a\u672c\n\nLOG_DIR=\"\/home\/wang\/n8n-article-system\/logs\"\nBACKUP_DIR=\"\/home\/wang\/n8n-article-system\/log-backups\"\n\n# \u521b\u5efa\u5907\u4efd\u76ee\u5f55\nmkdir -p \"$BACKUP_DIR\"\n\n# \u68c0\u67e5\u65e5\u5fd7\u76ee\u5f55\u662f\u5426\u5b58\u5728\nif &#91; ! -d \"$LOG_DIR\" ]; then\n    echo \"\u26a0\ufe0f  \u65e5\u5fd7\u76ee\u5f55\u4e0d\u5b58\u5728: $LOG_DIR\"\n    exit 1\nfi\n\n# \u5907\u4efd\u5e76\u6e05\u7406\u65e7\u65e5\u5fd7\nTIMESTAMP=$(date +%Y%m%d_%H%M%S)\n\n# \u5982\u679c\u6709\u65e5\u5fd7\u6587\u4ef6\u5c31\u5907\u4efd\nif ls \"$LOG_DIR\"\/*.log 1&gt; \/dev\/null 2&gt;&amp;1; then\n    # \u521b\u5efa\u5907\u4efd\n    tar -czf \"$BACKUP_DIR\/logs_$TIMESTAMP.tar.gz\" -C \"$LOG_DIR\" .\/*.log 2&gt;\/dev\/null\n    \n    # \u6e05\u7a7a\u65e5\u5fd7\u6587\u4ef6\uff08\u4e0d\u5220\u9664\uff0c\u53ea\u6e05\u7a7a\u5185\u5bb9\uff09\n    for logfile in \"$LOG_DIR\"\/*.log; do\n        if &#91; -f \"$logfile\" ]; then\n            &gt; \"$logfile\"  # \u6e05\u7a7a\u6587\u4ef6\u5185\u5bb9\n            echo \"\ud83d\udd04 \u6e05\u7a7a\u65e5\u5fd7\u6587\u4ef6: $(basename \"$logfile\")\"\n        fi\n    done\n    \n    echo \"\u2705 \u65e5\u5fd7\u8f6e\u8f6c\u5b8c\u6210\"\n    echo \"\ud83d\udce6 \u5907\u4efd\u4f4d\u7f6e: $BACKUP_DIR\/logs_$TIMESTAMP.tar.gz\"\nelse\n    echo \"\u2139\ufe0f  \u6ca1\u6709\u627e\u5230\u65e5\u5fd7\u6587\u4ef6\uff0c\u8df3\u8fc7\u8f6e\u8f6c\"\nfi\n\n# \u5220\u966430\u5929\u524d\u7684\u65e7\u5907\u4efd\nfind \"$BACKUP_DIR\" -name \"*.tar.gz\" -mtime +30 -delete\necho \"\ud83d\uddd1\ufe0f  \u5df2\u6e05\u740630\u5929\u524d\u7684\u65e7\u5907\u4efd\"<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u6d4b\u8bd5\u811a\u672c<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6d4b\u8bd5\u5907\u4efd\u811a\u672c\n.\/backup.sh\n\n# \u6d4b\u8bd5\u65e5\u5fd7\u8f6e\u8f6c\u811a\u672c\n.\/log-rotate.sh\n\n# \u67e5\u770b\u5907\u4efd\u6587\u4ef6\nls -la backups\/\nls -la log-backups\/<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d66-1024x772.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"772\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d66-1024x772.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1002\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p><strong>\u8bbe\u7f6e\u5b9a\u65f6\u4efb\u52a1\uff08\u53ef\u9009\uff09<\/strong><\/p>\n\n\n\n<p>\u5982\u679c\u4f60\u60f3\u8981\u81ea\u52a8\u8fd0\u884c\u8fd9\u4e9b\u811a\u672c\uff0c\u53ef\u4ee5\u8bbe\u7f6e\u5b9a\u65f6\u4efb\u52a1\uff1alsl<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u7f16\u8f91\u5f53\u524d\u7528\u6237\u7684crontab\ncrontab -e<\/code><\/pre>\n\n\n\n<p><strong>\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6bcf\u5929\u51cc\u66682\u70b9\u6267\u884c\u5907\u4efd\n0 2 * * * \/home\/wang\/n8n-article-system\/backup.sh\n\n# \u6bcf\u5468\u4e00\u51cc\u66683\u70b9\u6267\u884c\u65e5\u5fd7\u8f6e\u8f6c\n0 3 * * 1 \/home\/wang\/n8n-article-system\/log-rotate.sh<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u6700\u7ec8\u76ee\u5f55\u7ed3\u6784<\/h2>\n\n\n\n<p>\u73b0\u5728\u7684\u76ee\u5f55\u7ed3\u6784\u5e94\u8be5\u662f\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>~\/n8n-article-system\/\n\u251c\u2500\u2500 docker-compose.yml\n\u251c\u2500\u2500 backup.sh\n\u251c\u2500\u2500 log-rotate.sh\n\u251c\u2500\u2500 database\/          # \u81ea\u52a8\u751f\u6210\n\u251c\u2500\u2500 articles\/          # \u81ea\u52a8\u751f\u6210\uff08\u5de5\u4f5c\u6d41\u521b\u5efa\u540e\uff09\n\u251c\u2500\u2500 backups\/           # \u5907\u4efd\u6587\u4ef6\n\u2514\u2500\u2500 log-backups\/       # \u65e5\u5fd7\u5907\u4efd<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d67.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"954\" height=\"464\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d67.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1003\"  sizes=\"auto, (max-width: 954px) 100vw, 954px\" \/><\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL \u65b9\u6848<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u66f4\u65b0 docker-compose.yml<\/strong><\/h3>\n\n\n\n<p>\u5728\u73b0\u6709\u7684 n8n \u914d\u7f6e\u57fa\u7840\u4e0a\u6dfb\u52a0 MySQL \u670d\u52a1\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>services:\n  n8n:\n    image: n8nio\/n8n\n    container_name: n8n-article-system\n    restart: unless-stopped\n    ports:\n      - \"5678:5678\"\n    environment:\n      - N8N_DEFAULT_BINARY_DATA_MODE=filesystem\n      - DB_TYPE=mysqldb\n      - DB_MYSQLDB_HOST=mysql\n      - DB_MYSQLDB_DATABASE=n8n\n      - DB_MYSQLDB_USER=n8n_user\n      - DB_MYSQLDB_PASSWORD=your_mysql_password\n      - TZ=Asia\/Shanghai\n      - N8N_DEFAULT_TIMEZONE=Asia\/Shanghai\n      - N8N_ENCRYPTION_KEY=change-this-to-a-random-secure-key\n    volumes:\n      - .\/database:\/home\/node\/.n8n\/database\n      - .\/articles:\/home\/node\/.n8n\/articles\n      - .\/logs:\/home\/node\/.n8n\/logs\n    depends_on:\n      - mysql\n    networks:\n      - n8n-network\n\n  mysql:\n    image: mysql:8.0\n    container_name: n8n-mysql\n    restart: unless-stopped\n    environment:\n      MYSQL_ROOT_PASSWORD: your_root_password\n      MYSQL_DATABASE: n8n\n      MYSQL_USER: n8n_user\n      MYSQL_PASSWORD: your_mysql_password\n    volumes:\n      - mysql_data:\/var\/lib\/mysql\n      - .\/mysql\/init:\/docker-entrypoint-initdb.d\n    networks:\n      - n8n-network\n\nvolumes:\n  mysql_data:\n\nnetworks:\n  n8n-network:\n    driver: bridge<\/code><\/pre>\n\n\n\n<p><strong>\u521b\u5efa\u5fc5\u8981\u7684\u76ee\u5f55\u548c\u521d\u59cb\u5316\u811a\u672c<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u5728 n8n-article-system \u76ee\u5f55\u4e0b\u521b\u5efa MySQL \u76f8\u5173\u76ee\u5f55\ncd ~\/n8n-article-system\nmkdir -p mysql\/init\n\n# \u521b\u5efa\u6570\u636e\u5e93\u521d\u59cb\u5316\u811a\u672c\uff08\u53ef\u9009\uff09\nnano mysql\/init\/01-create-schemas.sql<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u4fee\u6539\u5907\u4efd\u811a\u672c\u652f\u6301 MySQL<\/strong><\/h3>\n\n\n\n<p>\u66f4\u65b0\u4f60\u7684&nbsp;backup.sh&nbsp;\u811a\u672c\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\nBACKUP_DIR=\"\/home\/wang\/n8n-article-system\/backups\/$(date +%Y%m%d_%H%M%S)\"\necho \"\ud83d\udce6 \u521b\u5efa\u5907\u4efd: $BACKUP_DIR\"\n\nmkdir -p \"$BACKUP_DIR\"\n\n# \u5907\u4efd MySQL \u6570\u636e\u5e93\necho \"\ud83d\uddc4\ufe0f  \u5907\u4efd MySQL \u6570\u636e\u5e93...\"\ndocker exec n8n-mysql mysqldump -u root -p\"your_root_password\" n8n &gt; \"$BACKUP_DIR\/mysql-backup.sql\" 2&gt;\/dev\/null\nif &#91; $? -eq 0 ]; then\n    echo \"\u2705 MySQL \u6570\u636e\u5e93\u5907\u4efd\u5b8c\u6210\"\nelse\n    echo \"\u274c MySQL \u5907\u4efd\u5931\u8d25\"\nfi\n\n# \u5907\u4efd\u6587\u4ef6\u6570\u636e\ncp -r \/home\/wang\/n8n-article-system\/articles \"$BACKUP_DIR\/\" 2&gt;\/dev\/null &amp;&amp; echo \"\u2705 \u6587\u7ae0\u5907\u4efd\u5b8c\u6210\"\ncp -r \/home\/wang\/n8n-article-system\/logs \"$BACKUP_DIR\/\" 2&gt;\/dev\/null &amp;&amp; echo \"\u2705 \u65e5\u5fd7\u5907\u4efd\u5b8c\u6210\"\n\n# \u521b\u5efa\u538b\u7f29\u5305\ntar -czf \"$BACKUP_DIR.tar.gz\" \"$BACKUP_DIR\" 2&gt;\/dev\/null\nrm -rf \"$BACKUP_DIR\"\n\necho \"\ud83c\udf89 \u5907\u4efd\u5b8c\u6210: $BACKUP_DIR.tar.gz\"<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u90e8\u7f72\u6b65\u9aa4<\/h3>\n\n\n\n<p><strong>\u505c\u6b62\u73b0\u6709\u670d\u52a1<\/strong>\uff08\u5982\u679c\u6b63\u5728\u8fd0\u884c\uff09\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd ~\/n8n-article-system\ndocker-compose down<\/code><\/pre>\n\n\n\n<p><strong>\u66f4\u65b0 docker-compose.yml<\/strong>\uff1a\u7528\u4e0a\u9762\u7684\u914d\u7f6e\u66ff\u6362\u73b0\u6709\u5185\u5bb9<\/p>\n\n\n\n<p><strong>\u4fee\u6539\u5bc6\u7801<\/strong>\uff1a\u5c06&nbsp;your_mysql_password&nbsp;\u548c&nbsp;your_root_password&nbsp;\u6539\u4e3a\u5f3a\u5bc6\u7801<\/p>\n\n\n\n<p><strong>\u542f\u52a8\u65b0\u670d\u52a1<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker-compose up -d<\/code><\/pre>\n\n\n\n<p><strong>\u68c0\u67e5\u670d\u52a1\u72b6\u6001<\/strong>\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker-compose ps<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">n8n \u4e2d MySQL \u8282\u70b9\u7684\u914d\u7f6e<\/h3>\n\n\n\n<p>\u5728 n8n \u5de5\u4f5c\u6d41\u4e2d\u4f7f\u7528 MySQL \u8282\u70b9\u65f6\uff0c\u914d\u7f6e\u5982\u4e0b\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Host<\/strong>:&nbsp;mysql&nbsp;(Docker \u5bb9\u5668\u540d)<\/li>\n\n\n\n<li><strong>Database<\/strong>:&nbsp;n8n<\/li>\n\n\n\n<li><strong>User<\/strong>:&nbsp;n8n_user<\/li>\n\n\n\n<li><strong>Password<\/strong>:&nbsp;your_mysql_password<\/li>\n\n\n\n<li><strong>Port<\/strong>:&nbsp;<code>3306<\/code>&nbsp;(\u9ed8\u8ba4)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u5e38\u89c1\u95ee\u9898<\/h3>\n\n\n\n<p>\u5982\u679c\u4f60\u8fd0\u884c\u4e4b\u540e\uff0c\u53d1\u73b0\u65e0\u6cd5\u8bbf\u95ee\u9875\u9762\uff0c\u4f46\u662f\u5bb9\u5668\u53c8\u6b63\u5e38\u8fd0\u884c\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d610-1024x129.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"129\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d610-1024x129.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1010\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>\u7136\u540e\u4f60\u8fd0\u884c<strong><em>docker logs n8n-article-system<\/em><\/strong>,\u8fd4\u56de\u7ed3\u679c\u6211\u4eec\u53ea\u770b\u6700\u540e\u51e0\u884c<\/p>\n\n\n\n<p>n8n ready on ::, port 5678<br>Migrations in progress, please do NOT stop the process.<br>Starting migration AddWorkflowVersionColumn1761047826451<br>Migration &#8220;AddWorkflowVersionColumn1761047826451&#8221; failed, error: Duplicate column name &#8216;versionCounter&#8217;<br>There was an error running database migrations<br>Duplicate column name &#8216;versionCounter&#8217;<br>Permissions 0644 for n8n settings file \/home\/node\/.n8n\/config are too wide. This is ignored for now, but in the future n8n will attempt to change the permissions automatically. To automatically enforce correct permissions now set N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=true (recommended), or turn this check off set N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=false.\u7136\u540e\u6211\u4eec\u53ef\u4ee5\u53d1\u73b0n8n\u662f\u51c6\u5907\u57285678\u7aef\u53e3\u4e0a\u7684<strong><em>docker exec -it n8n-mysql mysql -u root -p&#8221;preluna&#8221; n8n<\/em><\/strong>\uff0c\u4f46\u662f\u8fd9\u91cc\u7684\u95ee\u9898\u662f\u5728\u4e8e\u6570\u636e\u5e93\u6587\u4ef6\u91cd\u590d\u521b\u65b0\u7684\u95ee\u9898\u3002\uff08sqlite\u4e0emysql\u51b2\u7a81\uff09,\u6240\u4ee5\u6211\u4eec\u8fdb\u5165mysql\u5bb9\u5668,\u63a5\u7740\u8f93\u5165<strong><em>DESCRIBE workflow_entity;<\/em><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d611-1024x366.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"366\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d611-1024x366.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1011\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>\u8f93\u5165 <strong><em>INSERT IGNORE INTO migrations (timestamp, name)<br>       VALUES (1761047826451, &#8216;AddWorkflowVersionColumn1761047826451&#8217;);<\/em><\/strong><\/p>\n\n\n\n<p>\u8f93\u5165exit\u9000\u51fa<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u6838\u5fc3\u5de5\u4f5c\u6d41\u914d\u7f6e<\/h2>\n\n\n\n<p>\u9996\u5148\uff0c\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u5de5\u4f5c\u6d41\uff0c\u5e76\u6309\u7167\u4ee5\u4e0b\u8282\u70b9\u987a\u5e8f\u8fdb\u884c\u914d\u7f6e\u3002\u8fd9\u5957\u6d41\u7a0b\u4f1a\u5f15\u5bfc\u4f60\u4eceWordPress\u83b7\u53d6\u6587\u7ae0\uff0c\u7136\u540e\u5b58\u5165SQLite\u6570\u636e\u5e93\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u8282\u70b9\u7c7b\u578b<\/th><th>\u5173\u952e\u914d\u7f6e<\/th><th>\u4e3b\u8981\u7528\u9014<\/th><\/tr><\/thead><tbody><tr><td><strong>Schedule Trigger<\/strong><\/td><td>\u89c4\u5219\uff1a0 *\/6 * * *&nbsp;(\u6bcf6\u5c0f\u65f6)<\/td><td>\u5b9a\u65f6\u81ea\u52a8\u542f\u52a8\u5de5\u4f5c\u6d41<\/td><\/tr><tr><td><strong>HTTP Request<\/strong><\/td><td>\u65b9\u6cd5\uff1aGET<br>URL\uff1ahttps:\/\/\u4f60\u7684\u7f51\u7ad9\u57df\u540d\/wp-json\/wp\/v2\/posts<br>\u8ba4\u8bc1\uff1aBasic Auth<\/td><td>\u83b7\u53d6WordPress\u6587\u7ae0\u5217\u8868<\/td><\/tr><tr><td><strong>Code<\/strong><\/td><td>\u6a21\u5f0f\uff1aRun once for all items<br>\u89e3\u6790JSON\uff0c\u63d0\u53d6\u6240\u9700\u5b57\u6bb5<\/td><td>\u6e05\u6d17\u548c\u683c\u5f0f\u5316API\u8fd4\u56de\u7684\u6570\u636e<\/td><\/tr><tr><td><strong>SQLite<\/strong><\/td><td>\u64cd\u4f5c\uff1aExecute Query<br>\u521b\u5efaarticles\u8868\u5e76\u63d2\u5165\u6570\u636e<\/td><td>\u5c06\u5904\u7406\u540e\u7684\u6587\u7ae0\u6570\u636e\u5b58\u5165\u6570\u636e\u5e93<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u4e0b\u9762\u662f\u6bcf\u4e2a\u8282\u70b9\u7684\u8be6\u7ec6\u914d\u7f6e\u8bf4\u660e<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u914d\u7f6e Schedule Trigger \u8282\u70b9<\/strong><\/h3>\n\n\n\n<p>\u8fd9\u4e2a\u8282\u70b9\u8d1f\u8d23\u6309\u8ba1\u5212\u542f\u52a8\u6574\u4e2a\u6d41\u7a0b\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5728\u8282\u70b9\u53c2\u6570\u4e2d\uff0c\u5c06<strong>Trigger Times<\/strong>\u7684\u89c4\u5219\uff08Rule\uff09\u8bbe\u7f6e\u4e3a&nbsp;0 *\/6 * * *\uff0c\u8fd9\u4ee3\u8868\u6bcf6\u5c0f\u65f6\u81ea\u52a8\u8fd0\u884c\u4e00\u6b21\u3002\u60a8\u53ef\u4ee5\u6839\u636e\u9700\u8981\u8c03\u6574\u9891\u7387\u3002<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u914d\u7f6e HTTP Request \u8282\u70b9<\/strong><\/h3>\n\n\n\n<p>\u8fd9\u662f\u4e0eWordPress\u7ad9\u70b9\u901a\u4fe1\u7684\u5173\u952e\u8282\u70b9<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u65b9\u6cd5 (Method)<\/strong>\uff1a\u9009\u62e9&nbsp;<code>GET<\/code>\u3002<\/li>\n\n\n\n<li><strong>URL<\/strong>\uff1a\u586b\u5199\u4f60\u7684WordPress\u6587\u7ae0API\u7aef\u70b9\uff1ahttps:\/\/\u4f60\u7684\u7f51\u7ad9\u57df\u540d\/wp-json\/wp\/v2\/posts<a href=\"http:\/\/cms.douhao.com\/jiaocheng\/c915f53c5b03ce84.html\" target=\"_blank\" rel=\"noreferrer noopener\"><\/a>\u3002\u4f60\u53ef\u4ee5\u5728URL\u4e2d\u6dfb\u52a0\u53c2\u6570\uff0c\u4f8b\u5982&nbsp;?per_page=5&nbsp;\u6765\u9650\u5236\u9996\u6b21\u6d4b\u8bd5\u7684\u6587\u7ae0\u6570\u91cf\u3002<\/li>\n\n\n\n<li><strong>\u8ba4\u8bc1 (Authentication)<\/strong>\uff1a\u9009\u62e9&nbsp;<strong>Generic Credential<\/strong>&nbsp;\u7c7b\u578b\u4e0b\u7684&nbsp;<strong>Basic Auth<\/strong>\u3002\n<ul class=\"wp-block-list\">\n<li><strong>Username<\/strong>\uff1a\u586b\u5199\u4f60\u7684WordPress\u7ba1\u7406\u5458\u7528\u6237\u540d\u3002<\/li>\n\n\n\n<li><strong>Password<\/strong>\uff1a\u8fd9\u91cc\u9700\u8981\u586b\u5199\u4f60\u751f\u6210\u7684<strong>\u5e94\u7528\u7a0b\u5e8f\u5bc6\u7801<\/strong>\uff08Application Password\uff09\uff0c\u800c\u975e\u4f60\u7684\u767b\u5f55\u5bc6\u7801\u3002\u4f60\u53ef\u4ee5\u5728WordPress\u540e\u53f0\u7684\u201c\u7528\u6237\u201d-&gt;\u201c\u4e2a\u4eba\u8d44\u6599\u201d\u9875\u9762\u5e95\u90e8\u751f\u6210\u5b83<a href=\"https:\/\/www.idcspy.com\/138677.html\" target=\"_blank\" rel=\"noreferrer noopener\"><\/a>\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d68.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"584\" height=\"641\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d68.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1006\"  sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/div><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d69-1024x327.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"327\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d69-1024x327.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1007\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u914d\u7f6e Code \u8282\u70b9<\/strong><\/h3>\n\n\n\n<p>WordPress API\u8fd4\u56de\u7684\u6570\u636e\u7ed3\u6784\u6bd4\u8f83\u590d\u6742\uff0c\u8fd9\u4e2a\u8282\u70b9\u7528\u4e8e\u63d0\u53d6\u6211\u4eec\u9700\u8981\u7684\u4fe1\u606f\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5c06<strong>\u6a21\u5f0f (Mode)<\/strong>&nbsp;\u8bbe\u7f6e\u4e3a&nbsp;Run once for all items\u3002<\/li>\n\n\n\n<li>\u5728\u4ee3\u7801\u6846\u4e2d\u8f93\u5165\u4ee5\u4e0bJavaScript\u4ee3\u7801\uff0c\u5b83\u5c06\u539f\u59cb\u6570\u636e\u8f6c\u6362\u4e3a\u66f4\u7ed3\u6784\u5316\u7684\u683c\u5f0f<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ \u4ece\u4e0a\u6e38HTTP Request\u8282\u70b9\u8bfb\u53d6\u539f\u59cb\u6587\u7ae0\u5217\u8868\u6570\u636e\nconst rawArticles = $input.all();\n\n\/\/ \u5bf9\u6bcf\u7bc7\u6587\u7ae0\u8fdb\u884c\u6620\u5c04\uff0c\u63d0\u53d6\u6211\u4eec\u5173\u5fc3\u7684\u5b57\u6bb5\nconst articles = rawArticles.map(article =&gt; {\n  return {\n    wp_id: article.json.id,\n    title: article.json.title.rendered,\n    slug: article.json.slug,\n    url: article.json.link,\n    status: article.json.status,\n    content: article.json.content.rendered,\n    modified: article.json.modified,\n    \/\/ \u8ba1\u7b97\u5185\u5bb9\u54c8\u5e0c\uff0c\u7528\u4e8e\u540e\u7eed\u5224\u65ad\u6587\u7ae0\u662f\u5426\u66f4\u65b0\n    content_hash: Buffer.from(article.json.content.rendered).toString('base64').substring(0, 64)\n  };\n});\n\n\/\/ \u5c06\u5904\u7406\u597d\u7684\u6587\u7ae0\u6570\u7ec4\u8fd4\u56de\u7ed9\u4e0b\u4e00\u4e2a\u8282\u70b9\nreturn articles;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL\u521d\u59cb\u5316\u8282\u70b9\u914d\u7f6e<\/h3>\n\n\n\n<p><strong>\u51ed\u8bc1\u914d\u7f6e<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Connection Type<\/strong>: MySQL<\/li>\n\n\n\n<li><strong>Host<\/strong>:\u00a0<code>mysql<\/code>\u00a0\u2b50\uff08\u5fc5\u987b\u4f7f\u7528\u5bb9\u5668\u540d\uff09<\/li>\n\n\n\n<li><strong>Database<\/strong>:\u00a0<code>n8n<\/code>\uff08n8n \u7cfb\u7edf\u6570\u636e\u5e93\uff09<\/li>\n\n\n\n<li><strong>User<\/strong>:\u00a0<code>n8n_user<\/code><\/li>\n\n\n\n<li><strong>Password<\/strong>: \u4f60\u7684MySQL\u5bc6\u7801<\/li>\n\n\n\n<li><strong>Port<\/strong>:\u00a0<code>3306<\/code><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u6570\u636e\u5e93\u5206\u79bb(\u53ef\u9009)<\/h3>\n\n\n\n<p>\u5982\u679c\u4f60\u60f3\u50cf\u6211\u4e00\u6837\u8fdb\u884c\u6570\u636e\u5e93\u5206\u79bb\u7684\u8bdd\u3002<\/p>\n\n\n\n<p><strong>\u6b65\u9aa41\uff1a\u521b\u5efa\u6b63\u786e\u7684\u76ee\u5f55\u7ed3\u6784<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd ~\/n8n-article-system\nmkdir -p mysql-init\n\n# \u521b\u5efa\u521d\u59cb\u5316\u811a\u672c\nnano mysql-init\/01-create-article-system.sql<\/code><\/pre>\n\n\n\n<p><strong>\u6b65\u9aa42\uff1a\u7f16\u5199\u521d\u59cb\u5316\u811a\u672c\u5185\u5bb9<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u6587\u4ef6: 01-create-article-system.sql\n-- \u521b\u5efa\u6587\u7ae0\u7cfb\u7edf\u6570\u636e\u5e93\nCREATE DATABASE IF NOT EXISTS article_system CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n\n-- \u6388\u4e88 n8n_user \u7528\u6237\u6743\u9650\uff08\u7528\u6237\u5df2\u5728\u73af\u5883\u53d8\u91cf\u4e2d\u521b\u5efa\uff09\nGRANT ALL PRIVILEGES ON article_system.* TO 'n8n_user'@'%';\n\n-- \u5237\u65b0\u6743\u9650\nFLUSH PRIVILEGES;\n\n-- \u53ef\u9009\uff1a\u9a8c\u8bc1\u521b\u5efa\u6210\u529f\nSELECT 'article_system \u6570\u636e\u5e93\u521d\u59cb\u5316\u5b8c\u6210' as status;<\/code><\/pre>\n\n\n\n<p><strong>\u6b65\u9aa43\uff1a\u9a8c\u8bc1\u811a\u672c\u8bed\u6cd5<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u9a8c\u8bc1 SQL \u8bed\u6cd5\uff08\u53ef\u9009\uff09\ndocker exec n8n-mysql mysql -u root -p\u4f60\u7684\u5bc6\u7801 -e \"SOURCE \/docker-entrypoint-initdb.d\/01-create-article-system.sql;\" 2>&amp;1<\/code><\/pre>\n\n\n\n<p><strong>\u6b65\u9aa44\uff1a\u786e\u4fdd Docker \u914d\u7f6e\u6b63\u786e<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql:\n  image: mysql:8.0\n  container_name: n8n-mysql\n  restart: unless-stopped\n  environment:\n    MYSQL_ROOT_PASSWORD: \u4f60\u7684root\u5bc6\u7801\n    MYSQL_DATABASE: n8n\n    MYSQL_USER: n8n_user\n    MYSQL_PASSWORD: \u4f60\u7684MySQL\u5bc6\u7801\n  volumes:\n    - mysql_data:\/var\/lib\/mysql\n    - .\/mysql-init:\/docker-entrypoint-initdb.d  # \u5173\u952e\u6302\u8f7d\u70b9\n  networks:\n    - n8n-network<\/code><\/pre>\n\n\n\n<p><strong>\u91cd\u542f\u670d\u52a1\u5e76\u67e5\u770b\u65e5\u5fd7<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker-compose down<br>docker-compose up -d mysql<br>docker-compose logs mysql | grep -A 10 -B 10 \"Initializing database\"<\/code><\/pre>\n\n\n\n<p><strong>\u9a8c\u8bc1\u6570\u636e\u5e93\u521b\u5efa<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u7b49\u5f85 MySQL \u5b8c\u5168\u542f\u52a8\u540e\u68c0\u67e5\u6570\u636e\u5e93\nsleep 10\ndocker exec n8n-mysql mysql -u n8n_user -p\u4f60\u7684\u5bc6\u7801 -e \"SHOW DATABASES;\"<\/code><\/pre>\n\n\n\n<p><strong>\u5e94\u8be5\u770b\u5230\u8f93\u51fa\u4e2d\u5305\u542b\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>+--------------------+\n| Database           |\n+--------------------+\n| article_system     |  \u2b50 \u8fd9\u4e2a\u5c31\u662f\u521d\u59cb\u5316\u811a\u672c\u521b\u5efa\u7684\n| information_schema |\n| n8n                |\n| performance_schema |\n+--------------------+<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d612.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"344\" height=\"151\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d612.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1015\"  sizes=\"auto, (max-width: 344px) 100vw, 344px\" \/><\/div><\/figure>\n\n\n\n<p><strong>\u8fdb\u5165\u5bb9\u5668\u68c0\u67e5\u6587\u4ef6<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u68c0\u67e5\u521d\u59cb\u5316\u811a\u672c\u662f\u5426\u6b63\u786e\u6302\u8f7d\ndocker exec n8n-mysql ls -la \/docker-entrypoint-initdb.d\/\n\n# \u5e94\u8be5\u770b\u5230\uff1a\n# -rw-r--r-- 1 1000 1000  1234 Jan 15 10:30 01-create-article-system.sql<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d613-1024x76.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"76\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d613-1024x76.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1016\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>\u540c\u7406\uff0c\u4f60\u7684\u51ed\u8bc1\u4e5f\u5e94\u8be5\u770b\u5230\u56fe\u7247\u8fd9\u6837\u7684\u4fee\u6539\uff0c\u53ea\u8981\u5c06\u6570\u636e\u5e93\u7684\u540d\u79f0\u6362\u6210\u4f60\u81ea\u5df1\u7684\u540d\u79f0\u5c31\u884c\u4e86\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d614.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"780\" height=\"681\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d614.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1018\"  sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><\/div><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d615-1006x1024.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1006\" height=\"1024\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d615-1006x1024.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1020\"  sizes=\"auto, (max-width: 1006px) 100vw, 1006px\" \/><\/div><\/figure>\n\n\n\n<p>\u6309\u7167\u56fe\u7247\u4e2d\u7684sql\u8fdb\u884c\u8fde\u63a5\u6d4b\u8bd5\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u5b8c\u6574\u7684\u8868\u7ed3\u6784\u8bbe\u8ba1<\/h4>\n\n\n\n<p>1. \u521b\u5efa\u6587\u7ae0\u8868<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u521b\u5efa\u6587\u7ae0\u4e3b\u8868\nCREATE TABLE IF NOT EXISTS articles (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    wp_id INT UNIQUE NOT NULL,                    -- WordPress \u6587\u7ae0 ID\n    title TEXT NOT NULL,                          -- \u6587\u7ae0\u6807\u9898\n    slug VARCHAR(200),                           -- URL \u522b\u540d\n    url VARCHAR(500) NOT NULL,                   -- \u5b8c\u6574\u6587\u7ae0 URL\n    status VARCHAR(20) DEFAULT 'publish',        -- \u6587\u7ae0\u72b6\u6001\n    content_hash VARCHAR(64),                    -- \u5185\u5bb9\u54c8\u5e0c\u503c\uff08\u7528\u4e8e\u68c0\u6d4b\u53d8\u66f4\uff09\n    md_file_path TEXT,                           -- \u751f\u6210\u7684 MD \u6587\u4ef6\u8def\u5f84\n    is_deleted TINYINT(1) DEFAULT 0,             -- \u6807\u8bb0\u662f\u5426\u88ab\u5220\u9664\n    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- \u8bb0\u5f55\u521b\u5efa\u65f6\u95f4\n    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- \u6700\u540e\u66f4\u65b0\u65f6\u95f4\n    last_sync TIMESTAMP NULL DEFAULT NULL,       -- \u6700\u540e\u540c\u6b65\u65f6\u95f4\n    last_modified TIMESTAMP NULL DEFAULT NULL,   -- \u6587\u7ae0\u6700\u540e\u4fee\u6539\u65f6\u95f4\uff08\u4ece WordPress \u83b7\u53d6\uff09\n    \n    -- \u7d22\u5f15\u4f18\u5316\n    INDEX idx_wp_id (wp_id),\n    INDEX idx_updated (updated_at),\n    INDEX idx_deleted (is_deleted),\n    INDEX idx_status (status),\n    INDEX idx_last_modified (last_modified),\n    INDEX idx_content_hash (content_hash)\n);<\/code><\/pre>\n\n\n\n<p><strong>2. \u521b\u5efa\u540c\u6b65\u5386\u53f2\u8868<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u521b\u5efa\u6587\u7ae0\u7248\u672c\u8868\uff08\u53ef\u9009\uff0c\u7528\u4e8e\u8be6\u7ec6\u8ffd\u8e2a\u5185\u5bb9\u53d8\u5316\uff09\nCREATE TABLE IF NOT EXISTS article_versions (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    wp_id INT NOT NULL,                           -- WordPress \u6587\u7ae0 ID\n    title TEXT,                                   -- \u6587\u7ae0\u6807\u9898\n    content_hash VARCHAR(64),                     -- \u5185\u5bb9\u54c8\u5e0c\n    version INT DEFAULT 1,                        -- \u7248\u672c\u53f7\n    change_type VARCHAR(20),                      -- \u53d8\u66f4\u7c7b\u578b\uff1anew, update, minor_edit\n    captured_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- \u6355\u83b7\u65f6\u95f4\n    \n    -- \u7d22\u5f15\u4f18\u5316\n    INDEX idx_wp_id_version (wp_id, version),\n    INDEX idx_captured (captured_at),\n    FOREIGN KEY (wp_id) REFERENCES articles(wp_id) ON DELETE CASCADE\n);<\/code><\/pre>\n\n\n\n<p>3. \u521b\u5efa\u6587\u7ae0\u7248\u672c\u8868\uff08\u7528\u4e8e\u8ffd\u8e2a\u5185\u5bb9\u53d8\u5316)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u521b\u5efa\u6587\u7ae0\u7248\u672c\u8868\uff08\u53ef\u9009\uff0c\u7528\u4e8e\u8be6\u7ec6\u8ffd\u8e2a\u5185\u5bb9\u53d8\u5316\uff09\nCREATE TABLE IF NOT EXISTS article_versions (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    wp_id INT NOT NULL,                           -- WordPress \u6587\u7ae0 ID\n    title TEXT,                                   -- \u6587\u7ae0\u6807\u9898\n    content_hash VARCHAR(64),                     -- \u5185\u5bb9\u54c8\u5e0c\n    version INT DEFAULT 1,                        -- \u7248\u672c\u53f7\n    change_type VARCHAR(20),                      -- \u53d8\u66f4\u7c7b\u578b\uff1anew, update, minor_edit\n    captured_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- \u6355\u83b7\u65f6\u95f4\n    \n    -- \u7d22\u5f15\u4f18\u5316\n    INDEX idx_wp_id_version (wp_id, version),\n    INDEX idx_captured (captured_at),\n    FOREIGN KEY (wp_id) REFERENCES articles(wp_id) ON DELETE CASCADE\n);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u5728 n8n \u5de5\u4f5c\u6d41\u4e2d\u6267\u884c SQL<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u5b8c\u6574\u7684\u521d\u59cb\u5316 SQL\uff08\u53ef\u91cd\u590d\u6267\u884c\uff09<\/h3>\n\n\n\n<p>\u5728 n8n \u7684 MySQL \u8282\u70b9\u4e2d\u4f7f\u7528\u8fd9\u4e2a\u5b8c\u6574\u7684 SQL\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u521d\u59cb\u5316\u6587\u7ae0\u7cfb\u7edf\u8868\u7ed3\u6784\uff08\u5e42\u7b49\u64cd\u4f5c\uff09\nUSE article_system;\n\n-- \u521b\u5efa\u6587\u7ae0\u4e3b\u8868\nCREATE TABLE IF NOT EXISTS articles (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    wp_id INT UNIQUE NOT NULL,\n    title TEXT NOT NULL,\n    slug VARCHAR(200),\n    url VARCHAR(500) NOT NULL,\n    status VARCHAR(20) DEFAULT 'publish',\n    content_hash VARCHAR(64),\n    md_file_path TEXT,\n    is_deleted TINYINT(1) DEFAULT 0,\n    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n    last_sync TIMESTAMP NULL DEFAULT NULL,\n    last_modified TIMESTAMP NULL DEFAULT NULL,\n    INDEX idx_wp_id (wp_id),\n    INDEX idx_updated (updated_at),\n    INDEX idx_deleted (is_deleted),\n    INDEX idx_status (status),\n    INDEX idx_last_modified (last_modified),\n    INDEX idx_content_hash (content_hash)\n);\n\n-- \u521b\u5efa\u540c\u6b65\u5386\u53f2\u8868\nCREATE TABLE IF NOT EXISTS sync_history (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    sync_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n    new_articles INT DEFAULT 0,\n    updated_articles INT DEFAULT 0,\n    deleted_articles INT DEFAULT 0,\n    sync_duration INT,\n    success TINYINT(1) DEFAULT 1,\n    error_message TEXT,\n    articles_checked INT DEFAULT 0,\n    INDEX idx_timestamp (sync_timestamp),\n    INDEX idx_success (success)\n);\n\n-- \u521b\u5efa\u6587\u7ae0\u7248\u672c\u8868\uff08\u53ef\u9009\uff09\nCREATE TABLE IF NOT EXISTS article_versions (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    wp_id INT NOT NULL,\n    title TEXT,\n    content_hash VARCHAR(64),\n    version INT DEFAULT 1,\n    change_type VARCHAR(20),\n    captured_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n    INDEX idx_wp_id_version (wp_id, version),\n    INDEX idx_captured (captured_at)\n);\n\n-- \u63d2\u5165\u521d\u59cb\u540c\u6b65\u8bb0\u5f55\nINSERT IGNORE INTO sync_history (id, new_articles, updated_articles, deleted_articles, sync_duration, articles_checked) \nVALUES (1, 0, 0, 0, 0, 0);\n\nSELECT '\u6570\u636e\u5e93\u8868\u7ed3\u6784\u521d\u59cb\u5316\u5b8c\u6210' as status;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u5b8c\u6574\u7684\u5de5\u4f5c\u6d41\u8bbe\u8ba1<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\u5de5\u4f5c\u6d41\u8282\u70b9\u7ed3\u6784\uff1a<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;\u624b\u52a8\u89e6\u53d1] \n    \u2192 &#91;\u521d\u59cb\u5316\u6570\u636e\u5e93\u8868] \n    \u2192 &#91;\u83b7\u53d6WordPress\u6587\u7ae0\u5217\u8868] \n    \u2192 &#91;\u5904\u7406\u6587\u7ae0\u6570\u636e] \n    \u2192 &#91;\u68c0\u6d4b\u53d8\u66f4] \n    \u2192 &#91;\u63d0\u53d6\u6587\u7ae0\u5185\u5bb9] \n    \u2192 &#91;\u751f\u6210MD\u6587\u4ef6] \n    \u2192 &#91;\u66f4\u65b0\u6570\u636e\u5e93\u8bb0\u5f55] \n    \u2192 &#91;\u8bb0\u5f55\u540c\u6b65\u5386\u53f2]<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">1. \u83b7\u53d6\u6587\u7ae0\u5217\u8868\u8282\u70b9\uff08HTTP Request\uff09<\/h4>\n\n\n\n<p>\u8c03\u7528 WordPress REST API\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ URL: https:\/\/\u4f60\u7684\u535a\u5ba2.com\/wp-json\/wp\/v2\/posts\n\/\/ \u53c2\u6570: ?per_page=100&amp;orderby=modified&amp;order=desc<\/code><\/pre>\n\n\n\n<p><strong>2. \u5904\u7406\u6587\u7ae0\u6570\u636e\u8282\u70b9\uff08Code\uff09<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ \u8ba1\u7b97\u5185\u5bb9\u54c8\u5e0c\u548c\u5904\u7406\u6570\u636e\nconst crypto = require('crypto');\n\nfunction calculateHash(content) {\n  return crypto.createHash('md5').update(content).digest('hex');\n}\n\nconst articles = $input.all().map(article => ({\n  wp_id: article.id,\n  title: article.title.rendered,\n  slug: article.slug,\n  url: article.link,\n  status: article.status,\n  content_hash: calculateHash(article.content.rendered),\n  last_modified: article.modified,\n  content: article.content.rendered,\n  excerpt: article.excerpt.rendered\n}));\n\nreturn articles;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">3. \u68c0\u6d4b\u53d8\u66f4\u8282\u70b9\uff08Code + MySQL\uff09<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ \u83b7\u53d6\u73b0\u6709\u6587\u7ae0\u8bb0\u5f55\u8fdb\u884c\u6bd4\u5bf9\nconst currentArticles = $input.all();\n\/\/ \u8fd9\u91cc\u9700\u8981\u4ece\u6570\u636e\u5e93\u67e5\u8be2\u73b0\u6709\u6587\u7ae0\u8bb0\u5f55\u8fdb\u884c\u6bd4\u5bf9\n\/\/ \u8fd4\u56de\u65b0\u589e\u3001\u66f4\u65b0\u3001\u5220\u9664\u7684\u6587\u7ae0\u5217\u8868<\/code><\/pre>\n\n\n\n<p><strong>4. \u8bb0\u5f55\u540c\u6b65\u5386\u53f2\u8282\u70b9\uff08MySQL\uff09<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \u63d2\u5165\u540c\u6b65\u8bb0\u5f55\nINSERT INTO sync_history (new_articles, updated_articles, deleted_articles, sync_duration, articles_checked, success) \nVALUES (?, ?, ?, ?, ?, 1);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u6570\u636e\u6301\u4e45\u5316\u4fdd\u8bc1<\/h2>\n\n\n\n<p>\u5509\uff0c\u4e3b\u64ad\u4e3b\u64ad\uff0c\u5982\u679c\u6211\u8fd9\u4e48\u4e00\u4e2a\u6d41\u7a0b\u6267\u884c\u5b8c\u4e4b\u540e\uff0c\u6211\u8fd9\u4e2a\u6570\u636e\u80fd\u4e0d\u80fd\u8fdb\u884c\u957f\u4e45\u5316\u4fdd\u5b58?\u5982\u679c\u6211\u7684\u8fd9\u4e2a\u5bb9\u5668\u8fdb\u884c\u4e86\u91cd\u542f\uff0c\u90a3\u662f\u4e0d\u662f\u6211\u8fd9\u4e9b\u6570\u636e\u90fd\u6e05\u96f6\u4e86\uff1f\u54ce\u5144\u5f1f\u4e0d\u4f1a\u7684\uff0c<strong>\u4f60\u7684\u6570\u636e\u4f1a\u6301\u4e45\u5316\u4fdd\u5b58\uff0c\u5373\u4f7f\u5bb9\u5668\u91cd\u542f\u4e5f\u4e0d\u4f1a\u4e22\u5931\u6570\u636e\u3002<\/strong>\u8ba9\u6211\u8be6\u7ec6\u89e3\u91ca\u6570\u636e\u6301\u4e45\u5316\u7684\u673a\u5236\uff1a<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6570\u636e\u6301\u4e45\u5316\u67b6\u6784:<\/h3>\n\n\n\n<p><strong>\u5f53\u524d\u7684\u6570\u636e\u5b58\u50a8\u8bbe\u8ba1\uff1a<\/strong>\u5bb9\u5668\u5185\u90e8 (\u6613\u5931) \u2190 \u5377\u6302\u8f7d \u2192 \u5bbf\u4e3b\u673a (\u6301\u4e45\u5316)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u6301\u4e45\u5316\u914d\u7f6e\u5206\u6790<\/strong><\/h3>\n\n\n\n<p><strong>n8n \u670d\u52a1\u7684\u5377\u914d\u7f6e\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>n8n:\n  volumes:\n    - .\/database:\/home\/node\/.n8n\/database      # \u5bbf\u4e3b\u673a\u76ee\u5f55\u6620\u5c04\n    - .\/articles:\/home\/node\/.n8n\/articles      # \u5bbf\u4e3b\u673a\u76ee\u5f55\u6620\u5c04  \n    - .\/logs:\/home\/node\/.n8n\/logs              # \u5bbf\u4e3b\u673a\u76ee\u5f55\u6620\u5c04<\/code><\/pre>\n\n\n\n<p><strong>mysql \u670d\u52a1\u7684\u5377\u914d\u7f6e\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql:\n  volumes:\n    - mysql_data:\/var\/lib\/mysql                    # Docker \u547d\u540d\u5377\n    - .\/mysql\/init:\/docker-entrypoint-initdb.d     # \u5bbf\u4e3b\u673a\u76ee\u5f55\u6620\u5c04<\/code><\/pre>\n\n\n\n<p><strong>\u5377\u58f0\u660e\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>volumes:\n  mysql_data:  # Docker \u547d\u540d\u5377\u58f0\u660e<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u67e5\u627e mysql_data \u5377\u7684\u4f4d\u7f6e<\/h3>\n\n\n\n<p><strong>\u65b9\u6cd51\uff1a\u67e5\u770b\u6240\u6709 Docker \u5377<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u5217\u51fa\u6240\u6709 Docker \u5377\ndocker volume ls<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d616.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"912\" height=\"121\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d616.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1025\"  sizes=\"auto, (max-width: 912px) 100vw, 912px\" \/><\/div><\/figure>\n\n\n\n<p><strong>\u65b9\u6cd52\uff1a\u67e5\u770b\u5177\u4f53\u5377\u4fe1\u606f<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u67e5\u770b mysql_data \u5377\u7684\u8be6\u7ec6\u4fe1\u606f\ndocker volume inspect n8n-article-system_mysql_data\n\n# \u6216\u8005\u4f7f\u7528\u9879\u76ee\u540d\u79f0\u524d\u7f00\ndocker volume inspect $(docker volume ls -q | grep mysql_data)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d617-1024x309.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"309\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d617-1024x309.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1026\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p><strong>\u65b9\u6cd53\uff1a\u68c0\u67e5\u5377\u7684\u5b9e\u9645\u5b58\u50a8\u8def\u5f84<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u67e5\u770b\u5377\u5728\u5bbf\u4e3b\u673a\u4e0a\u7684\u5b9e\u9645\u5b58\u50a8\u8def\u5f84\ndocker volume inspect n8n-article-system_mysql_data | grep Mountpoint<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d618-1024x38.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"38\" data-original=\"http:\/\/www.preluna.xyz\/wp-content\/uploads\/2025\/11\/n8n\u4e0e\u7f51\u9875\u63d0\u53d618-1024x38.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-1027\"  sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u00a0\u7406\u89e3\u4e24\u79cd\u5377\u7c7b\u578b\u7684\u533a\u522b<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u5377\u7c7b\u578b<\/th><th>\u793a\u4f8b<\/th><th>\u5b58\u50a8\u4f4d\u7f6e<\/th><th>\u53ef\u89c1\u6027<\/th><th>\u7ba1\u7406\u65b9\u5f0f<\/th><\/tr><\/thead><tbody><tr><td>\u7ba1\u7406\u65b9\u5f0f<\/td><td>.\/database:\/path<\/td><td>\u9879\u76ee\u76ee\u5f55\u5185<\/td><td>\u76f4\u63a5\u53ef\u89c1\u548c\u8bbf\u95ee<\/td><td>\u624b\u52a8\u7ba1\u7406<\/td><\/tr><tr><td>Docker \u547d\u540d\u5377<\/td><td>mysql_data:\/path<\/td><td>Docker \u5b58\u50a8\u533a\u57df<\/td><td>\u9700\u8981\u901a\u8fc7 Docker \u547d\u4ee4\u8bbf\u95ee<\/td><td>Docker \u81ea\u52a8\u7ba1\u7406<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u9879\u76ee\u76ee\u5f55\u7ed3\u6784<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>~\/n8n-article-system\/\n\u251c\u2500\u2500 docker-compose.yml\n\u251c\u2500\u2500 database\/          # n8n \u7684 SQLite \u6570\u636e\uff08\u5982\u679c\u4f7f\u7528\uff09\n\u251c\u2500\u2500 articles\/          # \u751f\u6210\u7684 MD \u6587\u4ef6\n\u251c\u2500\u2500 logs\/              # \u65e5\u5fd7\u6587\u4ef6\n\u251c\u2500\u2500 mysql\/\n\u2502   \u2514\u2500\u2500 init\/          # \u521d\u59cb\u5316\u811a\u672c\n\u2514\u2500\u2500 (mysql_data \u5377\u5728 Docker \u7ba1\u7406\u533a\u57df\uff0c\u4e0d\u5728\u6b64\u76ee\u5f55)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u9a8c\u8bc1\u5377\u914d\u7f6e\u662f\u5426\u5de5\u4f5c<\/h3>\n\n\n\n<p><strong>\u68c0\u67e5\u5377\u662f\u5426\u6b63\u5e38\u6302\u8f7d\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u68c0\u67e5 MySQL \u5bb9\u5668\u5185\u7684\u5377\u6302\u8f7d\ndocker exec n8n-mysql ls -la \/var\/lib\/mysql\n\n# \u68c0\u67e5\u521d\u59cb\u5316\u811a\u672c\u662f\u5426\u6302\u8f7d\ndocker exec n8n-mysql ls -la \/docker-entrypoint-initdb.d\/<\/code><\/pre>\n\n\n\n<p><strong>\u9a8c\u8bc1\u6570\u636e\u6301\u4e45\u5316\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u521b\u5efa\u6d4b\u8bd5\u6570\u636e\ndocker exec n8n-mysql mysql -u n8n_user -ppreluna -e \"CREATE DATABASE IF NOT EXISTS test_persistence;\"\n\n# \u91cd\u542f\u670d\u52a1\ndocker-compose restart\n\n# \u68c0\u67e5\u6570\u636e\u662f\u5426\u8fd8\u5728\ndocker exec n8n-mysql mysql -u n8n_user -ppreluna -e \"SHOW DATABASES;\" | grep test_persistence<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u5982\u4f55\u8bbf\u95ee mysql_data \u5377\u7684\u6570\u636e<\/h3>\n\n\n\n<p>\u867d\u7136 mysql_data \u4e0d\u5728\u9879\u76ee\u76ee\u5f55\u4e2d\uff0c\u4f46\u4f60\u4ecd\u7136\u53ef\u4ee5\u8bbf\u95ee\uff1a<\/p>\n\n\n\n<p><strong>\u5907\u4efd mysql_data \u5377\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u5907\u4efd\u6574\u4e2a MySQL \u6570\u636e\ndocker run --rm -v n8n-article-system_mysql_data:\/source -v $(pwd):\/backup alpine tar czf \/backup\/mysql-backup.tar.gz -C \/source .<\/code><\/pre>\n\n\n\n<p><strong>\u67e5\u770b\u5377\u5185\u5bb9\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u4e34\u65f6\u6302\u8f7d\u5377\u67e5\u770b\u5185\u5bb9\ndocker run --rm -v n8n-article-system_mysql_data:\/data alpine ls -la \/data<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u521b\u5efa Docker Compose \u6587\u4ef6 \u9996\u5148\uff0c\u4f60\u9700\u8981\u521b\u5efa\u5e76\u7f16\u8f91&nbsp;docker-compose.ym [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,55,29],"tags":[],"class_list":["post-994","post","type-post","status-publish","format-standard","hentry","category-tech-writing","category-technology","category-efficient-workflow"],"_links":{"self":[{"href":"http:\/\/www.preluna.xyz\/index.php\/wp-json\/wp\/v2\/posts\/994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.preluna.xyz\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.preluna.xyz\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.preluna.xyz\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.preluna.xyz\/index.php\/wp-json\/wp\/v2\/comments?post=994"}],"version-history":[{"count":10,"href":"http:\/\/www.preluna.xyz\/index.php\/wp-json\/wp\/v2\/posts\/994\/revisions"}],"predecessor-version":[{"id":1029,"href":"http:\/\/www.preluna.xyz\/index.php\/wp-json\/wp\/v2\/posts\/994\/revisions\/1029"}],"wp:attachment":[{"href":"http:\/\/www.preluna.xyz\/index.php\/wp-json\/wp\/v2\/media?parent=994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.preluna.xyz\/index.php\/wp-json\/wp\/v2\/categories?post=994"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.preluna.xyz\/index.php\/wp-json\/wp\/v2\/tags?post=994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}