{"id":1307,"date":"2008-02-26T14:20:05","date_gmt":"2008-02-26T19:20:05","guid":{"rendered":"http:\/\/blogs.terrorware.com\/geoff\/2008\/02\/13\/ssh-cheatsheat\/"},"modified":"2008-02-26T14:21:12","modified_gmt":"2008-02-26T19:21:12","slug":"ssh-cheatsheat","status":"publish","type":"post","link":"https:\/\/blogs.terrorware.com\/geoff\/2008\/02\/26\/ssh-cheatsheat\/","title":{"rendered":"ssh cheatsheat"},"content":{"rendered":"

Port forwarding<\/h3>\n

from http:\/\/www.openssh.com\/faq.html#2.11<\/a><\/p>\n

\n
$ ssh -f -L 1234:server.example.com:6667 server.example.com sleep 10<\/strong><\/pre>\n<\/blockquote>\n
Backing up files over SSH<\/h3>\n
\n
$ ssh remote_host \"tar -zc -C \/path\/to\/parent\/directory -f - some_directory\" | cat > some_directory-`datestr`.tar.gz<\/pre>\n<\/blockquote>\n
Backing up a postgres database over SSH<\/h3>\n
\n
$ ssh remote_host \"pg_dump --username=db_user db_name\" | gzip  > db_name-`datestr`.sql.gz<\/pre>\n<\/blockquote>\n
<\/blockquote>\n","protected":false},"excerpt":{"rendered":"
Port forwarding from http:\/\/www.openssh.com\/faq.html#2.11 $ ssh -f -L 1234:server.example.com:6667 server.example.com sleep 10 Backing up files over SSH $ ssh remote_host “tar -zc -C \/path\/to\/parent\/directory -f – some_directory” | cat > some_directory-`datestr`.tar.gz Backing up a postgres database over SSH $ ssh remote_host “pg_dump –username=db_user db_name” | gzip > db_name-`datestr`.sql.gz<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4,5],"tags":[427,516,285,428],"class_list":["post-1307","post","type-post","status-publish","format-standard","hentry","category-note-to-self","category-howto","tag-cheatsheet","tag-deincarceration","tag-recipes","tag-ssh","entry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4wnIz-l5","_links":{"self":[{"href":"https:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/posts\/1307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/comments?post=1307"}],"version-history":[{"count":0,"href":"https:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/posts\/1307\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/media?parent=1307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/categories?post=1307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/tags?post=1307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}