{"id":1022,"date":"2012-08-14T13:44:36","date_gmt":"2012-08-14T05:44:36","guid":{"rendered":"http:\/\/rais.my\/blog\/?p=1022"},"modified":"2012-08-14T13:49:20","modified_gmt":"2012-08-14T05:49:20","slug":"windows-backup-mysql-secara-berkala","status":"publish","type":"post","link":"https:\/\/rais.my\/blog\/windows-backup-mysql-secara-berkala\/","title":{"rendered":"Windows : Backup mysql secara berkala"},"content":{"rendered":"<p>Assalam,<\/p>\n<p>Kebanyakkan server pangkalan data mysql menggunakan linux sebagai os dan tidak ketinggalan windows. Di sini kita share serba sedikit bagaimana nak backup secara berkala mysql.<\/p>\n<p>1. Create fail .bak<\/p>\n<pre class=\"brush:php\">REM fail backup.bat untuk backup mysql dengan nama yyyy-mm-dd.sql\r\n@echo off\r\ncd C:\\[nama_folder]\\mysql\\bin\r\nmysqldump.exe --user=user_anda --password=password_anda -A > C:\\[nama_folder]\\daily-%date:~6,4%-%date:~3,2%-%date:~0,2%.sql<\/pre>\n<p>[nama_folder] = folder mengikut persekitaran anda<\/p>\n<p>2. Gunakan Schedule Task yang terdapat pada windows untuk run scrip ini. Dengan ini kita dah boleh set sama ada backup dilakukan daily, weekly mahupun hourly.<\/p>\n<p>Selamat mencuba<\/p>\n<p><a href=\"http:\/\/rais.my\">rais.my<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Assalam, Kebanyakkan server pangkalan data mysql menggunakan linux sebagai os dan tidak ketinggalan windows. Di sini kita share serba sedikit bagaimana nak backup secara berkala mysql. 1. Create fail .bak REM fail backup.bat untuk backup mysql dengan nama yyyy-mm-dd.sql @echo off cd C:\\[nama_folder]\\mysql\\bin mysqldump.exe &#8211;user=user_anda &#8211;password=password_anda -A > C:\\[nama_folder]\\daily-%date:~6,4%-%date:~3,2%-%date:~0,2%.sql [nama_folder] = folder mengikut persekitaran anda [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cybocfi_hide_featured_image":"","footnotes":""},"categories":[274,74,532],"tags":[535,661,379,536,537],"class_list":["post-1022","post","type-post","status-publish","format-standard","hentry","category-database","category-mysql","category-tip","tag-backup","tag-mysql","tag-mysqldump","tag-schedule-task","tag-windows"],"_links":{"self":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/comments?post=1022"}],"version-history":[{"count":4,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1022\/revisions"}],"predecessor-version":[{"id":1026,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/1022\/revisions\/1026"}],"wp:attachment":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/media?parent=1022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/categories?post=1022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/tags?post=1022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}