{"id":575,"date":"2011-03-20T10:21:15","date_gmt":"2011-03-20T02:21:15","guid":{"rendered":"http:\/\/rais.my\/blog\/?p=575"},"modified":"2011-04-22T08:21:19","modified_gmt":"2011-04-22T00:21:19","slug":"dump-dan-restore-mysql","status":"publish","type":"post","link":"https:\/\/rais.my\/blog\/dump-dan-restore-mysql\/","title":{"rendered":"Dump dan restore &#8211; MySQL"},"content":{"rendered":"<p>Dump ALL MySQL Databases &#8211; semua pangkalan data<\/p>\n<pre class=\"brush:html\">mysqldump --user=XXXXXXXX --password=XXXXXXX -A > C:\\PATH\\TO\\DUMPFILE.SQL<\/pre>\n<p>Dump Individual or Multiple MySQL Databases &#8211; pangkalan data tertentu sahaja<\/p>\n<pre class=\"brush:html\">mysqldump --user=XXXXXXXX --password=XXXXXXX --databases NAMA_DB1 NAMA_DB2 NAMA_DB3 > C:\\PATH\\TO\\DUMPFILE.SQL<\/pre>\n<p>Dump only certain tables from a MySQL Database &#8211; table tertentu sahaja<\/p>\n<pre class=\"brush:html\">mysqldump --user=XXXXXXXX --password=XXXXXXXX --databases NAMA_DB --tables NAMA_TABLE > C:\\PATH\\TO\\DUMPFILE.SQL<\/pre>\n<p>Sekiranya dump dilakukan pada versi MySQL yang lain dengan versi yang ingin dimuatkan. Boleh gunakan arahan di bawah supaya dump file sesuai: <\/p>\n<pre class=\"brush:html\"> --compatible=mysql323<\/pre>\n<p>Berikut ialah arahan bagi memasukkan semula ke pangkalan data :<\/p>\n<pre class=\"brush:html\">mysql --user=XXXXXXXX --password=XXXXXXXX NAMA_DB < C:\\PATH\\TO\\DUMPFILE.SQL<\/pre>\n<p>Selamat Mencuba.<\/p>\n<p><a href=\"http:\/\/rais.my\">rais.my<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dump ALL MySQL Databases &#8211; semua pangkalan data mysqldump &#8211;user=XXXXXXXX &#8211;password=XXXXXXX -A > C:\\PATH\\TO\\DUMPFILE.SQL Dump Individual or Multiple MySQL Databases &#8211; pangkalan data tertentu sahaja mysqldump &#8211;user=XXXXXXXX &#8211;password=XXXXXXX &#8211;databases NAMA_DB1 NAMA_DB2 NAMA_DB3 > C:\\PATH\\TO\\DUMPFILE.SQL Dump only certain tables from a MySQL Database &#8211; table tertentu sahaja mysqldump &#8211;user=XXXXXXXX &#8211;password=XXXXXXXX &#8211;databases NAMA_DB &#8211;tables NAMA_TABLE > C:\\PATH\\TO\\DUMPFILE.SQL [&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,26,188,1],"tags":[381,661,379,382,380],"class_list":["post-575","post","type-post","status-publish","format-standard","hentry","category-database","category-mysql","category-opensource","category-pangkalan-data","category-umum","tag-dump","tag-mysql","tag-mysqldump","tag-restore","tag-verbose"],"_links":{"self":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/575","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=575"}],"version-history":[{"count":4,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/575\/revisions"}],"predecessor-version":[{"id":623,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/posts\/575\/revisions\/623"}],"wp:attachment":[{"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/media?parent=575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/categories?post=575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rais.my\/blog\/wp-json\/wp\/v2\/tags?post=575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}