{"id":602,"date":"2022-09-21T12:41:17","date_gmt":"2022-09-21T04:41:17","guid":{"rendered":"https:\/\/www.jchj.top\/?p=602"},"modified":"2025-09-26T11:26:53","modified_gmt":"2025-09-26T03:26:53","slug":"zabbix%e7%9a%84%e5%af%bc%e5%85%a5%e4%b8%8e%e5%a4%87%e4%bb%bd","status":"publish","type":"post","link":"https:\/\/www.jchj.top\/?p=602","title":{"rendered":"zabbix\u7684\u5bfc\u5165\u4e0e\u5907\u4efd"},"content":{"rendered":"\n<p><strong>\u538b\u7f29\u5907\u4efd<\/strong><strong>:<\/strong><\/p>\n\n\n\n<p>[root@localhost \/]# mysqldump -uroot -p123456 &#8211;opt zabbix | bzip2 &gt; zabbix.sql.bz2<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Bash<br>yum -y install bzip2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><br>[root@localhost \/]# ll zabbix.sql.bz2<br>-rw-r\u2013r&#8211; 1 root root 2353816 10-23 00:54 zabbix.sql.bz2<br>#\u2013opt Same as &#8211;add-drop-table, &#8211;add-locks, &#8211;create-options,<br>\u2013quick, &#8211;extended-insert, &#8211;lock-tables, &#8211;set-charset,<br>and &#8211;disable-keys. Enabled by default, disable with<br>\u2013skip-opt.<br>#\u7531\u4e8ezabbix\u5e93\u4e00\u822c\u6bd4\u8f83\u5927\uff0c\u6240\u4ee5\u4f7f\u7528bzip2\u8fdb\u884c\u538b\u7f29<\/p>\n\n\n\n<p>\u628a\u5907\u4efd\u6587\u4ef6\u4e0a\u4f20\u53e6\u4e00\u4e3b\u673a\u4e0a\uff0c\u770b\u80fd\u5426\u5bfc\u5165\u751f\u6548\u3002<\/p>\n\n\n\n<p>[root@localhost \/]# scp zabbix_config.sql root@10.0.0.251:\/root\/<br>zabbix_config.sql 100% 14MB 7.0MB\/s 00:02<\/p>\n\n\n\n<p>4.\u5bfc\u5165<\/p>\n\n\n\n<p>[root@localhost \/]# mysql zabbix &lt; zabbix_config.sql<\/p>\n\n\n\n<p><strong>\u76f4\u63a5\u5907\u4efd<\/strong><strong>:<\/strong><\/p>\n\n\n\n<p><strong>\u64cd\u4f5c\u6b65\u9aa4\uff1a<\/strong><\/p>\n\n\n\n<p><strong>1<\/strong><strong>\u3001\u5c06\u6570\u636e\u5e93<\/strong><strong>zabbix<\/strong><strong>\u5bfc\u51fa\u4e3a<\/strong><strong>zabbix.sql<\/strong><strong>\uff0c\u5e76\u538b\u7f29\u3002<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Bash<br>mysqldump -u zabbix -p &#8211;default-character-set=UTF8 &#8211;opt zabbix &gt; zabbix.sql<br>Enter password: ********<br>#\u65f6\u95f4\u6bd4\u8f83\u4e45\uff0c\u770b\u6570\u636e\u5e93\u6587\u4ef6\u7684\u5927\u5c0f\u3002<br>gzip zabbix.sql<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>2<\/strong><strong>\u3001\u5c06<\/strong><strong>zabbix.sql<\/strong><strong>\u4e0a\u4f20\u81f3\u65b0<\/strong><strong>zabbix<\/strong><strong>\u670d\u52a1\u5668\u7684<\/strong><strong>\/mnt<\/strong><strong>\u4e0b\uff0c\u6b65\u9aa4\u7565\u3002<\/strong><\/p>\n\n\n\n<p><strong>3<\/strong><strong>\u3001\u5c06<\/strong><strong>zabbix.sql<\/strong><strong>\u5bfc\u5165\u5230<\/strong><strong>zabbix<\/strong><strong>\u6570\u636e\u5e93\u4e2d<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>Bash<br>tar -dv zabbix.sql.gz<br>zcat \/mnt\/zabbix.sql.gz | mysql -uzabbix -p zabbix<br>Enter password: ********<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>4<\/strong><strong>\u3001\u5237\u65b0\u7f51\u9875\u5373\u53ef<\/strong><\/p>\n\n\n\n<p>\u9700\u8981\u6ce8\u610f\u7684\u4e8b\u60c5\u662f\u5bfc\u5165\u6570\u636e\u540e\u6240\u6709\u7684\u8d26\u53f7\u4fe1\u606f\u90fd\u53d8\u4e3a\u8001\u670d\u52a1\u5668\u7684\u4fe1\u606f\uff0c\u8fd9\u70b9\u9700\u8981\u6ce8\u610f\u4e0b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u538b\u7f29\u5907\u4efd: [root@localhost \/]#&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21,7,1],"tags":[],"class_list":["post-602","post","type-post","status-publish","format-standard","hentry","category-linux","category-7","category-1"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.jchj.top\/index.php?rest_route=\/wp\/v2\/posts\/602","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jchj.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jchj.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jchj.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jchj.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=602"}],"version-history":[{"count":1,"href":"https:\/\/www.jchj.top\/index.php?rest_route=\/wp\/v2\/posts\/602\/revisions"}],"predecessor-version":[{"id":603,"href":"https:\/\/www.jchj.top\/index.php?rest_route=\/wp\/v2\/posts\/602\/revisions\/603"}],"wp:attachment":[{"href":"https:\/\/www.jchj.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jchj.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jchj.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}