{"id":269,"date":"2020-06-13T09:09:25","date_gmt":"2020-06-13T01:09:25","guid":{"rendered":"http:\/\/www.gbase8.cn\/?p=269"},"modified":"2021-04-13T11:43:20","modified_gmt":"2021-04-13T03:43:20","slug":"gbase-8a%e9%9b%86%e7%be%a4%e5%af%bc%e5%87%ba%e6%95%b0%e6%8d%ae%e5%88%b0sftp%e9%9c%80%e8%a6%81%e4%bd%bf%e7%94%a8%e7%bb%9d%e5%af%b9%e8%b7%af%e5%be%84","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/269","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u96c6\u7fa4\u5bfc\u51fa\u6570\u636e\u5230sftp\u9700\u8981\u4f7f\u7528\u7edd\u5bf9\u8def\u5f84"},"content":{"rendered":"<p>sftp\u4e0d\u652f\u6301\u76f8\u5bf9\u8def\u5f84\uff0c\u5fc5\u987b\u4f7f\u7528\u7edd\u5bf9\u8def\u5f84\u624d\u53ef\u4ee5\u3002 \u800cftp\u534f\u8bae\u9ed8\u8ba4\u662f\u5f53\u524d\u7528\u6237\u7684\u76f8\u5bf9\u8def\u5f84\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase&gt; select * from t1 into outfile 'sftp:\/\/gbase:gbase@192.168.174.61\/home\/gbase\/123.txt' writemode by overwrites;\nQuery OK, 4 rows affected (Elapsed: 00:00:00.26)\n\ngbase&gt; system cat \/home\/gbase\/123.txt\n1\n2\n1\n2\ngbase&gt; select * from t1 into outfile 'sftp:\/\/gbase:gbase@192.168.174.61\/home\/gbase\/123.txt' writemode by overwrites with head;\nQuery OK, 4 rows affected (Elapsed: 00:00:00.34)\n\ngbase&gt; system cat \/home\/gbase\/123.txt\nid\n1\n2\n1\n2\ngbase&gt; \n\ngbase&gt; select * from t into outfile 'ftp:\/\/gbase:gbase1234@192.168.174.181\/t2_1_ftp.txt' fields terminated by ','  writemode by overwrites;\nQuery OK, 1 row affected (Elapsed: 00:00:00.08)\n\ngbase&gt; system ls \/home\/gbase -l;\ntotal 388768\n-rw-rw-r-- 1 gbase gbase        4 Jan 10 15:34 a.txt\n-rw-rw-r-- 1 gbase gbase    10918 Apr  8 12:02 create.sql\n-rw-rw-r-- 1 gbase gbase     6659 Apr  8 13:31 data_1.txt\n-rw-rw-r-- 1 gbase gbase 66602961 Apr  8 12:02 data.txt\ndrwx------ 2 gbase gbase       20 Jan 10 20:27 dba.out\ndrwxrwxr-x 3 gbase gbase     4096 May  6 14:41 gcinstall\n-rw-r--r-- 1 root  root  76122863 Jan 10 10:12 gcluster_backup_20190110101138.tar.bz2\n-rw-r--r-- 1 root  root  85046400 Feb 13 11:17 gcluster_backup_20190213111647.tar.bz2\n-rw-r--r-- 1 root  root  85098145 Feb 13 11:38 gcluster_backup_20190213113805.tar.bz2\n-rw-r--r-- 1 root  root  85066976 May  5 13:17 gcluster_backup_20190505131716.tar.bz2\ndrwxrwxr-x 3 gbase gbase     4096 May  5 14:40 loader_logs\n-rw-r--r-- 1 root  root      3050 May  6 13:26 ls\n-rw-r--r-- 1 root  root     22393 May  6 13:27 ls_0\n-rw-r--r-- 1 root  root     13133 May  6 13:27 ls1\ndrwx------ 2 gbase gbase       21 Jan 10 20:28 mask.out\ndrwxrwxr-x 2 gbase gbase        6 Dec 27 10:05 perl5\ndrwxr-xr-x 2 gbase gbase       19 May  5 13:35 t1.txt\ndrwxr-xr-x 2 gbase gbase       25 May  9 12:13 t2_1_ftp.txt\ndrwxr-xr-x 2 gbase gbase       21 May  9 12:13 t2_1.txt\n-rw-rw-r-- 1 gbase gbase        2 May  9 12:10 t2_2.txt\ndrwx------ 2 gbase gbase       19 Jan 10 10:31 t2.txt\n-rw-rw-r-- 1 gbase gbase    29700 Apr  8 12:56 testload.1w.log\n-rw-rw-r-- 1 gbase gbase    29000 Apr  8 13:59 testload.log\n-rw-rw-r-- 1 gbase gbase      222 Apr  8 13:32 testload.sh\ndrwx------ 2 gbase gbase       18 Jan 10 10:28 t.txt\ngbase&gt; select * from t into outfile 'ftp:\/\/gbase:gbase1234@192.168.174.181\/\/opt\/gbase\/t2_1_ftp_abs.txt' fields terminated by ','  writemode by overwrites;\nQuery OK, 1 row affected (Elapsed: 00:00:00.08)\n\ngbase&gt; system ls -l \/opt\/gbase\ntotal 0\ndrwxr-xr-x 7 gbase gbase 71 May  6 14:41 gcluster\ndrwxrwxr-x 3 gbase gbase 21 Dec 27 10:05 gc_userdata\ndrwxr-xr-x 7 gbase gbase 71 May  6 14:41 gnode\ndrwxrwxr-x 3 gbase gbase 18 Dec 27 10:05 gnode_userdata\ndrwxr-xr-x 2 gbase gbase 29 May  9 12:14 t2_1_ftp_abs.txt\ngbase&gt;\n<\/code><\/pre>","protected":false},"excerpt":{"rendered":"<p>\u5357\u5927\u901a\u7528GBase 8a\u96c6\u7fa4\u5bfc\u51fa\u6570\u636e\u5230sftp\u9700\u8981\u4f7f\u7528\u7edd\u5bf9\u8def\u5f84<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4],"tags":[22],"class_list":{"0":"post-269","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-gbase8a","8":"tag-22"},"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=269"}],"version-history":[{"count":3,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/269\/revisions"}],"predecessor-version":[{"id":5316,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/269\/revisions\/5316"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}