{"id":3575,"date":"2024-03-25T16:16:10","date_gmt":"2024-03-25T09:16:10","guid":{"rendered":"https:\/\/longvan.net\/cong-dong\/?p=3575"},"modified":"2024-07-07T08:57:29","modified_gmt":"2024-07-07T01:57:29","slug":"huong-dan-restore-du-lieu-mysql-bang-bussiness-backup-tren-linux","status":"publish","type":"post","link":"https:\/\/longvan.net\/cong-dong\/huong-dan-restore-du-lieu-mysql-bang-bussiness-backup-tren-linux\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn Restore d\u1eef li\u1ec7u MySQL b\u1eb1ng Bussiness Backup tr\u00ean Linux"},"content":{"rendered":"
    \n
  1. \n

    B\u01b0\u1edbc 1<\/strong>: Ki\u1ec3m tra c\u00e1c b\u1ea3n backup hi\u1ec7n c\u00f3. Th\u1ef1c hi\u1ec7n m\u1ed9t trong hai c\u00e1ch sau:<\/h3>\n
      \n
    • Ki\u1ec3m tra tr\u1ef1c ti\u1ebfp tr\u00ean server th\u00f4ng qua giao di\u1ec7n cmd<\/strong>.
      \n# cd \/usr\/local\/obm\/bin
      \n# <\/em>.\/ListBackupSet.sh
      \n<\/em>\"\"
      \nT\u1ea1i \u0111\u00e2y server s\u1ebd list ra c\u00e1c backup point theo backup set t\u01b0\u01a1ng \u1ee9ng
      \nL\u01b0u \u00fd ch\u00ednh x\u00e1c ng\u00e0y gi\u1edd \u0111\u1ec3 s\u1eed d\u1ee5ng cho vi\u1ec7c c\u1ea5u h\u00ecnh file restore \u1edf b\u01b0\u1edbc ti\u1ebfp theo.<\/li>\n
    • Ki\u1ec3m tra tr\u00ean trang qu\u1ea3n l\u00fd m\u00e0 Long V\u00e2n \u0111\u00e3 cung c\u1ea5p<\/span><\/strong>
      \nLogin v\u00e0o trang businessbk.longvan.net
      \nV\u00e0o m\u1ee5c User > Report > Backup Report for This User\u00a0<\/strong>
      \n\"\"
      \nSau \u0111\u00f3 ch\u1ecdn v\u00e0o backup set mu\u1ed1n thao t\u00e1c restore
      \n\"\"
      \nL\u01b0u \u00fd ch\u00ednh x\u00e1c ng\u00e0y gi\u1edd \u0111\u1ec3 s\u1eed d\u1ee5ng cho vi\u1ec7c c\u1ea5u h\u00ecnh file restore
      \nV\u00ed d\u1ee5: Th\u1eddi gian b\u1ea3n backup nh\u01b0 h\u00ecnh s\u1ebd c\u00f3 \u0111\u1ecbnh d\u1ea1ng 2023-12-24-12-00-00<\/li>\n<\/ul>\n<\/li>\n
    • \n

      B\u01b0\u1edbc 2: <\/strong>C\u1ea5u h\u00ecnh file Restore.sh<\/h3>\n
        \n
      • M\u1edf file Restore v\u1edbi l\u1ec7nh
        \n# vi \/usr\/local\/obm\/bin\/Restore.sh
        \n<\/em><\/li>\n
      • \u00a0T\u00f9y ch\u1ec9nh c\u00e1c th\u00f4ng s\u1ed1 c\u1ea5u h\u00ecnh nh\u01b0 sau:\n
        BACKUP_SET=\"default-backup-set-name-1\" # nh\u1eadp t\u00ean backup set\nRESTORE_TO=\"\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0                # nh\u1eadp \u0111\u01b0\u1eddng d\u1eabn folder \u0111\u00e3 backup\nRESTORE_FROM=\"MySQL\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0         # nh\u1eadp \u0111\u01b0\u1eddng d\u1eabn folder nh\u1eadn d\u1eef li\u1ec7u restore\nPOINT_IN_TIME=\"2023-12-24-12-00-00\"    # nh\u1eadp b\u1ea3n backup point, m\u1eb7c \u0111\u1ecbnh l\u00e0 Current (b\u1ea3n m\u1edbi)\nRESTORE_PERMISSION=\"Y\"\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0   # ch\u1ecdn Y \u0111\u1ec3 restore lu\u00f4n c\u1ea3 ph\u00e2n quy\u1ec1n c\u1ee7a file restore<\/pre>\n<\/li>\n<\/ul>\n<\/li>\n
      • \n
        B\u01b0\u1edbc 3<\/strong>: Th\u1ef1c hi\u1ec7n restore d\u1eef li\u1ec7u.<\/h3>\n
        Th\u1ef1c hi\u1ec7n restore v\u1edbi file restore v\u1eeba c\u1ea5u h\u00ecnh
        \n# cd \/usr\/local\/obm\/bin<\/em>
        \n# .\/Restore.sh
        \n<\/em>Ch\u1edd \u0111\u1ee3i qu\u00e1 tr\u00ecnh restore ti\u1ebfn h\u00e0nh, th\u1eddi gian ph\u1ee5 thu\u1ed9c v\u00e0o dung l\u01b0\u1ee3ng d\u1eef li\u1ec7u c\u1ea7n restore.
        \nSau khi Restore xong s\u1ebd hi\u1ec7n d\u00f2ng nh\u01b0 sau:
        \n\"\"<\/li>\n
      • \n
        B\u01b0\u1edbc 4<\/strong>: Ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u.<\/h3>\n
        Ki\u1ec3m tra tr\u1ef1c ti\u1ebfp l\u1ea1i d\u1eef li\u1ec7u xem \u0111\u00e3 restore \u0111\u1ea7y \u0111\u1ee7 ch\u01b0a
        \nHo\u1eb7c truy c\u1eadp trang\u00a0businessbk.longvan.net
        \nV\u00e0o m\u1ee5c User > Report >Restore<\/strong>
        \n\"\"
        \nHi\u1ec7n Status OK l\u00e0 th\u00e0nh c\u00f4ng.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
        B\u01b0\u1edbc 1: Ki\u1ec3m tra c\u00e1c b\u1ea3n backup hi\u1ec7n c\u00f3. Th\u1ef1c hi\u1ec7n m\u1ed9t trong hai c\u00e1ch sau: Ki\u1ec3m tra tr\u1ef1c ti\u1ebfp tr\u00ean server th\u00f4ng qua giao di\u1ec7n cmd. # cd \/usr\/local\/obm\/bin # .\/ListBackupSet.sh T\u1ea1i \u0111\u00e2y server s\u1ebd list ra c\u00e1c backup point theo backup set t\u01b0\u01a1ng \u1ee9ng L\u01b0u \u00fd ch\u00ednh x\u00e1c ng\u00e0y gi\u1edd \u0111\u1ec3 s\u1eed d\u1ee5ng […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_oasis_is_in_workflow":0,"_oasis_original":0,"footnotes":""},"categories":[18],"tags":[275,5,200],"class_list":["post-3575","post","type-post","status-publish","format-standard","hentry","category-bussiness-backup","tag-bussiness-backup","tag-linux","tag-restore"],"_links":{"self":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/3575","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/comments?post=3575"}],"version-history":[{"count":9,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/3575\/revisions"}],"predecessor-version":[{"id":5805,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/3575\/revisions\/5805"}],"wp:attachment":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/media?parent=3575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/categories?post=3575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/tags?post=3575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}