{"id":984,"date":"2013-10-08T03:44:26","date_gmt":"2013-10-07T19:44:26","guid":{"rendered":"https:\/\/umarzuki.org\/blogku\/?p=984"},"modified":"2013-10-08T03:44:26","modified_gmt":"2013-10-07T19:44:26","slug":"backup-mysql-dengan-netvault-backup","status":"publish","type":"post","link":"https:\/\/umarzuki.org\/blog\/2013\/10\/08\/backup-mysql-dengan-netvault-backup\/","title":{"rendered":"Backup MySQL dengan Netvault Backup"},"content":{"rendered":"<p>Contoh menggunakan:<br \/>\nNetvault Backup 8.53 pada Debian Squeeze 32-bit<br \/>\nMysql 5.1 pada Debian Squeeze 32-bit<\/p>\n<p>Pada server Mysql, tambah &#8220;log-bin=mysql-bin&#8221; dibawah bahagian [mysqld] di dalam \/etc\/mysql\/my.cnf untuk fungsi point-in-time restore.<\/p>\n<p>Restart service mysql.<br \/>\n\/etc\/init.d\/mysql restart<\/p>\n<p>Tambahkan server MySQL selepas memasang klien Netvault Backup.<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql00.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql00-300x224.png\" alt=\"add host\" width=\"300\" height=\"224\" class=\"alignnone size-medium wp-image-985\" \/><\/a><\/p>\n<p>Install plugin MySQL yang kita dah ekstrak kedalam server Netvault Backup.<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql01.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql01-300x223.png\" alt=\"plugin\" width=\"300\" height=\"223\" class=\"alignnone size-medium wp-image-986\" \/><\/a><\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql02.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql02-300x210.png\" alt=\"install mysql apm\" width=\"300\" height=\"210\" class=\"alignnone size-medium wp-image-987\" \/><\/a><\/p>\n<p>Pergi ke &#8220;Backup&#8221; &#038; double click MySQL APM untuk configure buat pertama kali.<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql03.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql03-300x295.png\" alt=\"apm mysql\" width=\"300\" height=\"295\" class=\"alignnone size-medium wp-image-988\" \/><\/a><\/p>\n<p>Setting MySQL Debian.<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql04.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql04-300x185.png\" alt=\"setting mysql \" width=\"300\" height=\"185\" class=\"alignnone size-medium wp-image-989\" \/><\/a><\/p>\n<p>Save saveset dengan nama yang sesuai.<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql05.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql05-300x295.png\" alt=\"mysql05\" width=\"300\" height=\"295\" class=\"alignnone size-medium wp-image-990\" \/><\/a><\/p>\n<p>Set untuk buat full backup semua database.<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql06.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql06-300x291.png\" alt=\"full\" width=\"300\" height=\"291\" class=\"alignnone size-medium wp-image-991\" \/><\/a><\/p>\n<p>Set untuk jadualkan pada setiap Jumaat 5.30 petang.<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql07.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql07-300x291.png\" alt=\"masa\" width=\"300\" height=\"291\" class=\"alignnone size-medium wp-image-992\" \/><\/a><\/p>\n<p>Set untuk backup ke VTL.<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql08.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql08-300x295.png\" alt=\"into vtl\" width=\"300\" height=\"295\" class=\"alignnone size-medium wp-image-994\" \/><\/a><\/p>\n<p>Save &#038; Submit (ikon floppy &#038; lampu trafik) setelah siap configure backup. Kemudian pergi ke &#8220;Job Management&#8221; dan uji job backup yang telah dijadualkan tadi. Right-click dan pilih &#8220;Run Now&#8230;&#8221;<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql09.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/mysql09-300x220.png\" alt=\"uji\" width=\"300\" height=\"220\" class=\"alignnone size-medium wp-image-995\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contoh menggunakan: Netvault Backup 8.53 pada Debian Squeeze 32-bit Mysql 5.1 pada Debian Squeeze 32-bit Pada server Mysql, tambah &#8220;log-bin=mysql-bin&#8221; dibawah bahagian [mysqld] di dalam \/etc\/mysql\/my.cnf untuk fungsi point-in-time restore. Restart service mysql. \/etc\/init.d\/mysql restart Tambahkan server MySQL selepas memasang klien Netvault Backup. Install plugin MySQL yang kita dah ekstrak kedalam server Netvault Backup. Pergi [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[240],"tags":[311,149,309],"class_list":["post-984","post","type-post","status-publish","format-standard","hentry","category-backup","tag-apm","tag-mysql","tag-netvault-backup"],"_links":{"self":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts\/984","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/comments?post=984"}],"version-history":[{"count":0,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts\/984\/revisions"}],"wp:attachment":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/media?parent=984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/categories?post=984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/tags?post=984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}