{"id":200,"date":"2014-07-28T13:37:40","date_gmt":"2014-07-28T07:37:40","guid":{"rendered":"https:\/\/workit.kz\/?p=200"},"modified":"2017-01-11T11:25:17","modified_gmt":"2017-01-11T05:25:17","slug":"ssh-backups","status":"publish","type":"post","link":"https:\/\/workit.kz\/?p=200","title":{"rendered":"\u0420\u0435\u0437\u0435\u0440\u0432\u043d\u0430\u044f \u043a\u043e\u043f\u0438\u044f \u0438 \u043f\u0435\u0440\u0435\u0434\u0430\u0447\u0430 \u0435\u0435 \u043d\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u043d\u044b\u0439 \u0441\u0435\u0440\u0432\u0435\u0440 SSH"},"content":{"rendered":"<p>\u0418\u0441\u0445\u043e\u0434\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435:<\/p>\r\n<ul>\r\n    <li>\u0421\u0435\u0440\u0432\u0435\u0440 \u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a CentOS 5 (web server)<\/li>\r\n    <li>\u0421\u0435\u0440\u0432\u0435\u0440 \u041f\u0440\u0438\u0435\u043c\u043d\u0438\u043a FreeBSD 7.3<\/li>\r\n<\/ul>\r\n<!--more-->\r\n<p>\u0417\u0430\u0434\u0430\u0447\u0430:<\/p>\r\n<ol>\r\n    <li>\u0420\u0435\u0437\u0435\u0440\u0432\u043d\u0430\u044f \u043a\u043e\u043f\u0438\u044f \u0441\u0442\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0439 \u043f\u0430\u043f\u043a\u0438 (\u0441\u043e\u0434\u0435\u0440\u0436\u0438\u043c\u043e\u0435 \u0432\u0435\u0431-\u0441\u0430\u0439\u0442\u0430), \u0441\u043e \u0441\u0436\u0430\u0442\u0438\u0435\u043c \u0438 \u043e\u043f\u0440\u0430\u0432\u043a\u043e\u0439 \u0430\u0440\u0445\u0438\u0432\u0430 \u043d\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u043d\u044b\u0439 \u0441\u0435\u0440\u0432\u0435\u0440.<\/li>\r\n    <li>\u0420\u0435\u0437\u0435\u0440\u0432\u043d\u0430\u044f \u043a\u043e\u043f\u0438\u044f \u0411\u0414 MySQL (\u0442\u043e\u0433\u043e \u0436\u0435 \u0432\u0435\u0431-\u0441\u0430\u0439\u0442\u0430),&#160;\u0441\u043e \u0441\u0436\u0430\u0442\u0438\u0435\u043c \u0438 \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u043e\u0439 \u0430\u0440\u0445\u0438\u0432\u0430 \u043d\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u043d\u044b\u0439 \u0441\u0435\u0440\u0432\u0435\u0440.<\/li>\r\n    <li>\u0414\u0435\u043b\u0430\u0442\u044c \u044d\u0442\u0438 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 \u043f\u043e \u0440\u0430\u0441\u043f\u0438\u0441\u0430\u043d\u0438\u044e, \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u0438 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0441\u0442\u0430\u0440\u044b\u0445 \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u044b\u0445 \u043a\u043e\u043f\u0438\u0439.<\/li>\r\n<\/ol>\r\n<p>\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u043c\u0435\u0436\u0434\u0443 \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u043c <strong>\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u043e\u043c<\/strong> \u0438 \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u043c <strong>\u041f\u0440\u0438\u0435\u043c\u043d\u0438\u043a\u043e\u043c<\/strong> \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u044b\u0445 \u043a\u043e\u043f\u0438\u0439 \u043f\u043e\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e\u043c SSH \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u0431\u0435\u0437 \u0432\u0432\u043e\u0434\u0430 \u043f\u0430\u0440\u043e\u043b\u044f:<\/p>\r\n<ul>\r\n    <li>\u0410\u0432\u0442\u043e\u0440\u0438\u0437\u0443\u0435\u043c\u0441\u044f \u043d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435 <strong>\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0435<\/strong> \u0447\u0435\u0440\u0435\u0437 SSH \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435.<\/li>\r\n    <li>\u0413\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u043c \u043a\u043b\u044e\u0447 \u0434\u043b\u044f \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f \u043f\u043e\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e\u043c SSH<\/li>\r\n    <li># ssh-keygen -t rsa<\/li>\r\n    <li>\u0412\u044b\u0431\u0435\u0440\u0438\u0442\u0435 \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u043f\u0443\u0442\u0438 ~\/.ssh\/id_rsa<\/li>\r\n    <li>\u041f\u0435\u0440\u0435\u043d\u043e\u0441\u0438\u043c \u043b\u044e\u0431\u044b\u043c \u0441\u043f\u043e\u0441\u043e\u0431\u043e\u043c ~\/.ssh\/id_rsa.pub \u043d\u0430 <strong>\u041f\u0440\u0438\u0435\u043c\u043d\u0438\u043a<\/strong><\/li>\r\n    <li>\u0410\u0432\u0442\u043e\u0440\u0438\u0437\u0443\u0435\u043c\u0441\u044f \u043d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435 <strong>\u041f\u0440\u0438\u0435\u043c\u043d\u0438\u043a\u0435<\/strong> \u0447\u0435\u0440\u0435\u0437 SSH \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435.<\/li>\r\n    <li>\u041d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435 <strong>\u041f\u0440\u0438\u0435\u043c\u043d\u0438\u043a\u0435<\/strong> \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c \u043a\u043e\u043c\u0430\u043d\u0434\u0443<\/li>\r\n    <li>$ cat \/home\/user2\/id_rsa.pub &gt;&gt; ~\/.ssh\/authorized_keys<\/li>\r\n<\/ul>\r\n<p>\u0421\u043e\u0437\u0434\u0430\u0435\u043c \u043f\u0430\u043f\u043a\u0443 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0445 \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u044b\u0445 \u043a\u043e\u043f\u0438\u0439 \u043d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435 <strong>\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0435<\/strong>:<\/p>\r\n<pre>\r\n# mkdir \/home\/source\/backup<\/pre>\r\n<p>\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 \u0441\u043a\u0440\u0438\u043f\u0442\u0430 \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0439 \u043a\u043e\u043f\u0438\u0438 \u0434\u0438\u0440\u0435\u043a\u0442\u043e\u0440\u0438\u0438&#160;\/home\/source\/www\/&#160;(\u0441\u0436\u0430\u0442\u0438\u0435 \u0432 \u0430\u0440\u0445\u0438\u0432 www.tgz):<\/p>\r\n<p>\u041d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435 <strong>\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0435<\/strong> \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0444\u0430\u0439\u043b \u0441\u043a\u0440\u0438\u043f\u0442 \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0439 \u043a\u043e\u043f\u0438\u0438 \u0434\u0438\u0440\u0435\u043a\u0442\u043e\u0440\u0438\u0438  \/home\/source\/www\/&#160;(\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \/home\/source\/backup-www.sh):<\/p>\r\n<pre>\r\n#!\/bin\/sh\r\n\r\ntar -cf \/home\/source\/backup\/www.tgz \/home\/source\/www\/\r\n<\/pre>\r\n<p>\u041e\u0431\u044a\u044f\u0441\u043d\u0435\u043d\u0438\u0435:&#160;\/home\/source\/backup\/www.tgz - \u043a\u0430\u043a \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u0433\u043b\u044f\u0434\u0435\u0442\u044c \u0433\u043e\u0442\u043e\u0432\u044b\u0439 \u0430\u0440\u0445\u0438\u0432 \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0439 \u043a\u043e\u043f\u0438\u0438 \u043f\u0430\u043f\u043a\u0438&#160;\/home\/source\/www\/<\/p>\r\n<p>\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 \u0441\u043a\u0440\u0438\u043f\u0442\u0430 \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0439 \u043a\u043e\u043f\u0438\u0438 \u0411\u0414 MySQL (\u0441\u0436\u0430\u0442\u0438\u0435 \u0432 \u0430\u0440\u0445\u0438\u0432 dump.sql.gz):<\/p>\r\n<p>\u041d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435 <strong>\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0435<\/strong> \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0444\u0430\u0439\u043b \u0441\u043a\u0440\u0438\u043f\u0442 \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0439 \u043a\u043e\u043f\u0438\u0438 \u0411\u0414 MySQL (\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \/home\/source\/backup-sql.sh):<\/p>\r\n<pre>\r\n#!\/bin\/sh\r\n\r\nmysqldump -u authuser --password=p@ssw0rd database | gzip &gt; \/home\/source\/backup\/dump.sql.gz<\/pre>\r\n<p>\u041e\u0431\u044a\u044f\u0441\u043d\u0435\u043d\u0438\u0435: \u0421\u043e\u0437\u0434\u0430\u0435\u043c \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u0443\u044e \u043a\u043e\u043f\u0438\u044e \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \"database\" \u0438 \u0441\u0436\u0438\u043c\u0430\u0435\u043c \u0435\u0435 \u0432 \u0430\u0440\u0445\u0438\u0432 \"dump.sql.gz\". \u0418\u043c\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0438 \u043f\u0430\u0440\u043e\u043b\u044c \u044f\u0432\u043d\u043e \u043f\u043e\u043d\u044f\u0442\u043d\u044b.<\/p>\r\n<p>\u041d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435 <strong>\u041f\u0440\u0438\u0435\u043c\u043d\u0438\u043a\u0435<\/strong> \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u043f\u0430\u043f\u043a\u0438 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0430\u0440\u0445\u0438\u0432\u043e\u0432:<\/p>\r\n<pre>\r\n$ mkdir ~\/backup-www\r\n\r\n$ mkdir ~\/backup-sql<\/pre>\r\n<p>\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 \u0441\u043a\u0440\u0438\u043f\u0442\u0430 \u0434\u043b\u044f \u043e\u0442\u043f\u0440\u0430\u0432\u043a\u0438 \u0430\u0440\u0445\u0438\u0432\u043e\u0432&#160;www.tgz \u0438&#160;dump.sql.gz \u0441 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 <strong>\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0430<\/strong> \u043d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440 <strong>\u041f\u0440\u0438\u0435\u043c\u043d\u0438\u043a<\/strong>, \u0441 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u043e\u0439 \u043d\u0430\u043b\u0438\u0447\u0438\u044f \u0430\u0440\u0445\u0438\u0432\u0430 \u0441\u0442\u0430\u0440\u0448\u0435 4 \u0434\u043d\u0435\u0439&#160;(\u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \/home\/source\/backup-scp.sh):<\/p>\r\n<pre>\r\n#!\/bin\/sh\r\nOLDDATE=`date --date='4 days ago' +%Y-%m-%d`;\r\nCURDATE=`date +%Y-%m-%d`;\r\nHOST=\"usersource@recepient.server.com\";\r\n\r\nOLDFILE=\"~\/backup-www\/$OLDDATE-www.tgz\";\r\nOLDSQLF=\"~\/backup-sql\/$OLDDATE-dump.sql.gz\";\r\n\r\nif ssh $HOST test -e \"$OLDFILE\" ;\r\nthen ssh $HOST \"rm $OLDFILE\";\r\nfi\r\n\r\nif ssh $HOST test -e \"$OLDSQLF\" ;\r\nthen ssh $HOST \"rm $OLDSQLF\";\r\nfi\r\n\r\nscp \/home\/source\/backup\/www.tgz $HOST:~\/backup-www\/$CURDATE-www.tgz\r\nscp \/home\/source\/backup\/dump.sql.gz $HOST:~\/backup-sql\/$CURDATE-dump.sql.gz\r\n<\/pre>\r\n<p>\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0443\u043a\u0430\u0437\u0430\u043d\u043d\u044b\u0445 \u0432\u044b\u0448\u0435 \u0441\u043a\u0440\u0438\u043f\u0442\u043e\u0432 (backup-www.sh, backup-sql.sh, backup-scp.sh) \u043f\u043e \u0440\u0430\u0441\u043f\u0438\u0441\u0430\u043d\u0438\u044e:<\/p>\r\n<p>\u041d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435 <strong>\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0435<\/strong> \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0437\u0430\u0434\u0430\u043d\u0438\u0435 cron \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439:<\/p>\r\n<pre>\r\n# crontab -e<\/pre>\r\n<ul>\r\n    <li>\u0421\u043a\u0440\u0438\u043f\u0442&#160;backup-www.sh \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c\u0441\u044f \u043a\u0430\u0436\u0434\u044b\u0439 \u0434\u0435\u043d\u044c \u0432 2:00<\/li>\r\n    <li>\u0421\u043a\u0440\u0438\u043f\u0442 backup-sql.sh \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c\u0441\u044f \u043a\u0430\u0436\u0434\u044b\u0439 \u0434\u0435\u043d\u044c \u0432 3:00<\/li>\r\n    <li>\u0421\u043a\u0440\u0438\u043f\u0442 backup-scp.sh \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c\u0441\u044f \u043a\u0430\u0436\u0434\u044b\u0439 \u0434\u0435\u043d\u044c \u0432 4:00<\/li>\r\n<\/ul>\r\n<p>\u041a\u0430\u043a \u044d\u0442\u043e \u0432\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u0432 \u0444\u0430\u0439\u043b\u0435 cron:<\/p>\r\n<pre>\r\n0   2   *   *   *   \/bin\/sh   \/home\/source\/bckp_www.sh\r\n0   3   *   *   *   \/bin\/sh   \/home\/source\/bckp_sql.sh\r\n0   4   *   *   *   \/bin\/sh   \/home\/source\/bckp_scp.sh\r\n<\/pre>\r\n<p>\u0412\u0441\u0435 \u0433\u043e\u0442\u043e\u0432\u043e!<\/p>","protected":false},"excerpt":{"rendered":"<p>\u0418\u0441\u0445\u043e\u0434\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435: \u0421\u0435\u0440\u0432\u0435\u0440 \u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a CentOS 5 (web server) \u0421\u0435\u0440\u0432\u0435\u0440 \u041f\u0440\u0438\u0435\u043c\u043d\u0438\u043a FreeBSD 7.3<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,4,2],"tags":[26,18,19],"_links":{"self":[{"href":"https:\/\/workit.kz\/index.php?rest_route=\/wp\/v2\/posts\/200"}],"collection":[{"href":"https:\/\/workit.kz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/workit.kz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/workit.kz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/workit.kz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=200"}],"version-history":[{"count":10,"href":"https:\/\/workit.kz\/index.php?rest_route=\/wp\/v2\/posts\/200\/revisions"}],"predecessor-version":[{"id":507,"href":"https:\/\/workit.kz\/index.php?rest_route=\/wp\/v2\/posts\/200\/revisions\/507"}],"wp:attachment":[{"href":"https:\/\/workit.kz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/workit.kz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/workit.kz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}