{"id":76013,"date":"2024-09-07T13:44:00","date_gmt":"2024-09-07T10:14:00","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/%d8%b5%d8%a7%d8%af%d8%b1%d8%a7%d8%aa-%d8%af%d8%a7%d8%af%d9%87-%d9%87%d8%a7-%d8%a7%d8%b2-mysql\/"},"modified":"2024-09-07T13:44:00","modified_gmt":"2024-09-07T10:14:00","slug":"%d8%b5%d8%a7%d8%af%d8%b1%d8%a7%d8%aa-%d8%af%d8%a7%d8%af%d9%87-%d9%87%d8%a7-%d8%a7%d8%b2-mysql","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/%d8%b5%d8%a7%d8%af%d8%b1%d8%a7%d8%aa-%d8%af%d8%a7%d8%af%d9%87-%d9%87%d8%a7-%d8%a7%d8%b2-mysql\/","title":{"rendered":"\u0635\u0627\u062f\u0631\u0627\u062a \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 MySQL"},"content":{"rendered":"

<\/p>\n

\u0628\u0633\u06cc\u0627\u0631 \u062e\u0648\u0628\u060c \u0686\u0648\u0646 \u0628\u0627\u06cc\u062f \u0628\u0647 \u06cc\u0627\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0645 \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 MySQL \u0635\u0627\u062f\u0631 \u06a9\u0646\u0645\u060c \u0628\u0627\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0627\u06cc\u0646\u062c\u0627 \u0628\u06af\u0630\u0627\u0631\u0645.\n<\/p>\n

\n
# export<\/span>\n<\/span>mysql<\/span> <\/span>--<\/span>defaults<\/span>-<\/span>file<\/span>=\/<\/span>data<\/span>\/<\/span>db<\/span>\/<\/span>mysql3366<\/span>\/<\/span>my.cnf<\/span> <\/span>-<\/span>S<\/span> <\/span>\/<\/span>data<\/span>\/<\/span>db<\/span>\/<\/span>mysql3366<\/span>\/<\/span>mysql3366.sock<\/span> <\/span>-<\/span>u<\/span> <\/span>[<\/span>user<\/span>]<\/span> <\/span>-<\/span>p<\/span> <\/span><<\/span> <\/span>select.sql<\/span> <\/span>|<\/span> <\/span>sed<\/span> <\/span>'s\/\\t\/\", \"\/g;s\/^\/\"\/;s\/$\"\/;s\/\\n\/\/g'<\/span> <\/span>><\/span> <\/span>.<\/span>\/<\/span>output_file.csv<\/span>\n\n<\/span># translate<\/span>\n<\/span>sed<\/span> <\/span>-<\/span>i<\/span> <\/span>'1s\/^\/\\xEF\\xBB\\xBF'<\/span> <\/span>.<\/span>\/<\/span>output_file.csv<\/span>\n\n<\/span><\/code><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
\u0628\u0633\u06cc\u0627\u0631 \u062e\u0648\u0628\u060c \u0686\u0648\u0646 \u0628\u0627\u06cc\u062f \u0628\u0647 \u06cc\u0627\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0645 \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 MySQL \u0635\u0627\u062f\u0631 \u06a9\u0646\u0645\u060c \u0628\u0627\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0627\u06cc\u0646\u062c\u0627 \u0628\u06af\u0630\u0627\u0631\u0645. # export mysql –defaults-file=\/data\/db\/mysql3366\/my.cnf -S \/data\/db\/mysql3366\/mysql3366.sock -u [user] -p < select.sql | sed ‘s\/\\t\/”, “\/g;s\/^\/”\/;s\/$”\/;s\/\\n\/\/g’ > .\/output_file.csv # translate sed -i ‘1s\/^\/\\xEF\\xBB\\xBF’ .\/output_file.csv<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-76013","post","type-post","status-publish","format-standard","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/76013","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=76013"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/76013\/revisions"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=76013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=76013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=76013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}