\u30b5\u30fc\u30d0\u30fc\u306b\u3042\u308bwordpress\u306eDB\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3088\u3046\u3068\u601d\u3044\u3001ssh\u3092\u8abf\u3079\u305f\u3002
\n\u30d5\u30a1\u30a4\u30eb\u306e\u8ee2\u9001\u306b\u624b\u8efd\u306a\u65b9\u6cd5\u304c\u306a\u304b\u3063\u305f\u305f\u3081\u6a19\u6e96\u51fa\u529b\u3092\u30d5\u30a1\u30a4\u30eb\u3078\u66f8\u304d\u51fa\u3059\u3053\u3068\u306b\u3002<\/p>\n
package main\r\n\r\nimport (\r\n\t\"io\/ioutil\"\r\n\t\"log\"\r\n\t\"os\"\r\n\r\n\t\"golang.org\/x\/crypto\/ssh\"\r\n)\r\n\r\nfunc main() {\r\n\r\n\thost := \"\"\r\n\tport := \"\"\r\n\tuser := \"\"\r\n\r\n\tbackupQuery := \"mysqldump\u3059\u308b\"\r\n\tdownloadQuery := \"cat\u3059\u308b\"\r\n\r\n\tbuf, err := ioutil.ReadFile(\"id_rsa.pem\") \/\/openssl rsa -in ~\/.ssh\/id_rsa -outform pem > id_rsa.pem\r\n\tif err != nil {\r\n\t\tlog.Print(err)\r\n\t\treturn\r\n\t}\r\n\tkey, err := ssh.ParsePrivateKey(buf)\r\n\tif err != nil {\r\n\t\tlog.Print(err)\r\n\t\treturn\r\n\t}\r\n\r\n\tconfig := &ssh.ClientConfig{\r\n\t\tUser: user,\r\n\t\tAuth: []ssh.AuthMethod{\r\n\t\t\tssh.PublicKeys(key),\r\n\t\t},\r\n\t\tHostKeyCallback: ssh.InsecureIgnoreHostKey(),\r\n\t}\r\n\r\n\tconn, err := ssh.Dial(\"tcp\", host+\":\"+port, config)\r\n\tif err != nil {\r\n\t\tlog.Print(err)\r\n\t\treturn\r\n\t}\r\n\tdefer conn.Close()\r\n\r\n\tbackupSession, err := conn.NewSession()\r\n\tif err != nil {\r\n\t\tlog.Print(err)\r\n\t\treturn\r\n\t}\r\n\tremoteCmd(backupQuery, backupSession)\r\n\r\n\tdownloadSession, err := conn.NewSession()\r\n\tif err != nil {\r\n\t\tlog.Print(err)\r\n\t\treturn\r\n\t}\r\n\tremoteCmd(downloadQuery, downloadSession)\r\n\r\n\tlog.Print(\"done\")\r\n}\r\n\r\nfunc remoteCmd(query string, session *ssh.Session) {\r\n\r\n\tdefer session.Close()\r\n\r\n\t\/\/\u30ea\u30e2\u30fc\u30c8\u306e\u6a19\u6e96\u51fa\u529b\u3092\u30ed\u30fc\u30ab\u30eb\u306e\u6a19\u6e96\u51fa\u529b\u3078\r\n\t\/\/session.Stdout = os.Stdout\r\n\r\n\tf, _ := os.Create(\"test.sql\")\r\n\tsession.Stdout = f\r\n\tsession.Stderr = os.Stderr\r\n\r\n\t\/*\r\n\t\tRun\u306fWait\u4ed8\u304d\u3002Start\u306fWait\u7121\u3057\r\n\t\t\u51fa\u529b\u306fsession\u306eStdio,Stderr\r\n\t\tsession\u306b\u4ed8\u304d\u30b3\u30de\u30f3\u30c9\u306f1\u5ea6\r\n\t*\/\r\n\r\n\tif err := session.Run(query); err != nil {\r\n\t\tlog.Print(err)\r\n\t\treturn\r\n\t}\r\n\r\n}\r\n<\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
\u30b5\u30fc\u30d0\u30fc\u306b\u3042\u308bwordpress\u306eDB\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3088\u3046\u3068\u601d\u3044\u3001ssh\u3092\u8abf\u3079\u305f\u3002 \u30d5\u30a1\u30a4\u30eb\u306e\u8ee2\u9001\u306b\u624b\u8efd\u306a\u65b9\u6cd5\u304c\u306a\u304b\u3063\u305f\u305f\u3081\u6a19\u6e96\u51fa\u529b\u3092\u30d5\u30a1\u30a4\u30eb\u3078\u66f8\u304d\u51fa\u3059\u3053\u3068\u306b\u3002 package main import ( “io\/iou … <\/p>\n