{"id":966,"date":"2013-10-07T23:37:18","date_gmt":"2013-10-07T15:37:18","guid":{"rendered":"https:\/\/umarzuki.org\/blogku\/?p=966"},"modified":"2013-10-07T23:37:18","modified_gmt":"2013-10-07T15:37:18","slug":"backup-mysql-dengan-mysqlbf","status":"publish","type":"post","link":"https:\/\/umarzuki.org\/blog\/2013\/10\/07\/backup-mysql-dengan-mysqlbf\/","title":{"rendered":"Backup MySQL dengan MySqlBF"},"content":{"rendered":"<p>Pada server MySQL, dalam \/etc\/mysql\/my.cnf tukar IP localhost ke IP sebenar server tersebut<br \/>\n[code lang=&#8217;plain&#8217;]#bind-address           = 127.0.0.1<br \/>\nbind-address            = 192.168.1.5[\/code]<\/p>\n<p>Restart servis MySQL<br \/>\n<code>\/etc\/init.d\/mysql restart<\/code><\/p>\n<p>Buatkan user bernama backup untuk backup dari IP 192.168.1.10 dengan kata laluan Do05esk7<\/p>\n<p><code>mysql -u root -p<br \/>\ngrant all on *.* to backup@'192.168.1.10' identified by 'Do05esk7';<br \/>\n\\q<\/code><\/p>\n<p>Sekarang cuba sambungkan MySqlBF dari 192.168.1.10 ke mysql server<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/set00.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/set00-300x190.png\" alt=\"login\" width=\"300\" height=\"190\" class=\"alignnone size-medium wp-image-967\" \/><\/a><\/p>\n<p>Tetapkan database yang hendak kita backup dan lokasi simpanannya<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/set01.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/set01-300x243.png\" alt=\"setting\" width=\"300\" height=\"243\" class=\"alignnone size-medium wp-image-968\" \/><\/a><\/p>\n<p>Contoh backup yang telah selesai, output pada destinasi dan laporan yang dihantar ke emel<\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/set02.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/set02-300x149.png\" alt=\"log\" width=\"300\" height=\"149\" class=\"alignnone size-medium wp-image-969\" \/><\/a><\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/set03.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/set03-300x191.png\" alt=\"output\" width=\"300\" height=\"191\" class=\"alignnone size-medium wp-image-970\" \/><\/a><\/p>\n<p><a href=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/set04.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/umarzuki.org\/blogku\/wp-content\/uploads\/2013\/10\/set04-300x202.png\" alt=\"emel\" width=\"300\" height=\"202\" class=\"alignnone size-medium wp-image-971\" \/><\/a><\/p>\n<p>Nota: Had versi percuma adalah 2 db sahaja<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada server MySQL, dalam \/etc\/mysql\/my.cnf tukar IP localhost ke IP sebenar server tersebut [code lang=&#8217;plain&#8217;]#bind-address = 127.0.0.1 bind-address = 192.168.1.5[\/code] Restart servis MySQL \/etc\/init.d\/mysql restart Buatkan user bernama backup untuk backup dari IP 192.168.1.10 dengan kata laluan Do05esk7 mysql -u root -p grant all on *.* to backup@&#8217;192.168.1.10&#8242; identified by &#8216;Do05esk7&#8217;; \\q Sekarang cuba sambungkan [&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":[46,307,149,308],"class_list":["post-966","post","type-post","status-publish","format-standard","hentry","category-backup","tag-backup","tag-gratis","tag-mysql","tag-percuma"],"_links":{"self":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts\/966","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=966"}],"version-history":[{"count":0,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/posts\/966\/revisions"}],"wp:attachment":[{"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/media?parent=966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/categories?post=966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/umarzuki.org\/blog\/wp-json\/wp\/v2\/tags?post=966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}