{"id":979,"date":"2020-11-20T12:45:16","date_gmt":"2020-11-20T11:45:16","guid":{"rendered":"https:\/\/cecetka.cp2.tuke.sk\/uvt\/wordpress\/?p=979"},"modified":"2020-11-20T13:04:18","modified_gmt":"2020-11-20T12:04:18","slug":"12-2-zalohovanie-os-a-mysql","status":"publish","type":"post","link":"https:\/\/robert.cecetka.website.tuke.sk\/?p=979","title":{"rendered":"12.2 Z\u00e1lohovanie OS a MySQL"},"content":{"rendered":"\n

Jedn\u00e1 sa o automatick\u00e9 z\u00e1lohovanie OS a MySQL datab\u00e1zy era_db. N\u00e1sledne prekop\u00edrovanie z\u00e1lohy na Veeam server.<\/p>\n\n\n\n

Vytvoril som 2 \u00falohy:<\/p>\n\n\n\n

prikazy<\/a>Stiahnu\u0165<\/a><\/div>\n\n\n\n
  1. \u00faloha zabezpe\u010d\u00ed vykonanie DUMP SQL datab\u00e1zy era_db
    1. Server –> MySQL Database Server –> era_db –> Backup Database<\/li>
    2. najprv sa spust\u00ed pr\u00edkaz, ktor\u00fd vyma\u017ee star\u0161ie z\u00e1lohy ako 7 dn\u00ed
      find \/root\/zalohy -type f -mtime +7 -exec rm -f {} \\;<\/strong><\/li>
    3. n\u00e1sledne sa vykon\u00e1 DUMP datab\u00e1zy era_db<\/strong><\/li>
    4. potom sa vykon\u00e1 pr\u00edkaz, ktor\u00fd prekop\u00edruje dan\u00fa z\u00e1lohu do nov\u00e9ho s\u00faboru, do ktor\u00e9ho n\u00e1zvu prid\u00e1 d\u00e1tam a \u010das.
      cp \/root\/zalohy\/zaloha-esmc-mysql.gzip „“\/root\/zalohy\/zaloha-esmc-mysql-„date +\"%d%B%Y-%T\"<\/code>.gzip“<\/strong><\/li>
    5. notifik\u00e1cia je nastaven\u00e1 na email av@tuke.sk<\/strong><\/li>
    6. z\u00e1loha sa vykon\u00e1va v\u017edy na cel\u00fa hodinu <\/li>
    7. kompresia je nastaven\u00e1 na GZIP<\/strong>

      <\/li><\/ol><\/li>
    8. \u00faloha zabezpe\u010d\u00ed prekop\u00edrovanie DUMP SQL na Veeam server
      1. Webmin –> Backup Configuration Files –> Scheduled backups<\/li>
      2. s\u00fabor sa kop\u00edruje do: \/mnt\/filer02_vol2\/rc\/esmc\/zaloha-esmc.7z<\/strong> , ktor\u00fd sa n\u00e1ch\u00e1dza na servere: veeam1-storage1.cloud.tuke.sk<\/strong>
        <\/li><\/ol><\/li>
      3. Pozn\u00e1mka
        1. pr\u00edkaz v linuxe na zmenu d\u00e1tumu vytvorenia s\u00faboru
          touch -d „100 days ago“ subor<\/strong><\/li>
        2. zmen\u00ed vytvorenie s\u00faboru o 100 dn\u00ed sp\u00e4\u0165.<\/li><\/ol><\/li><\/ol>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
          \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

          Jedn\u00e1 sa o automatick\u00e9 z\u00e1lohovanie OS a MySQL datab\u00e1zy era_db. N\u00e1sledne prekop\u00edrovanie z\u00e1lohy na Veeam server. Vytvoril som 2 \u00falohy: \u00faloha zabezpe\u010d\u00ed vykonanie DUMP SQL datab\u00e1zy era_db Server –> MySQL Database Server –> era_db –> Backup Database najprv sa spust\u00ed pr\u00edkaz, ktor\u00fd vyma\u017ee star\u0161ie z\u00e1lohy ako 7 dn\u00edfind \/root\/zalohy -type f -mtime +7 -exec rm …
          \u010c\u00edta\u0165 \u010falej 12.2 Z\u00e1lohovanie OS a MySQL<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[],"_links":{"self":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts\/979"}],"collection":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=979"}],"version-history":[{"count":11,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts\/979\/revisions"}],"predecessor-version":[{"id":994,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts\/979\/revisions\/994"}],"wp:attachment":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=979"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=979"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}