{"id":1786,"date":"2020-03-22T07:38:14","date_gmt":"2020-03-22T07:38:14","guid":{"rendered":"https:\/\/www.jetorbit.com\/panduan\/?p=1786"},"modified":"2020-10-16T10:26:09","modified_gmt":"2020-10-16T03:26:09","slug":"cara-export-backup-database-mysql-di-directadmin","status":"publish","type":"post","link":"https:\/\/www.jetorbit.com\/panduan\/cara-export-backup-database-mysql-di-directadmin\/","title":{"rendered":"Cara Export\/Backup Database MySQL di DirectAdmin"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Daftar Isi Artikel<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-export-backup-database-mysql-di-directadmin\/#Intro\" >Intro<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-export-backup-database-mysql-di-directadmin\/#Cara_Backup_Database_di_DirectAdmin_dengan_Mudah\" >Cara Backup Database di DirectAdmin dengan Mudah<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-export-backup-database-mysql-di-directadmin\/#Export_Database_MySQL_Melalui_phpMyAdmin\" >Export Database MySQL Melalui phpMyAdmin<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-export-backup-database-mysql-di-directadmin\/#Cara_Akses_phpMyAdmin_di_DirectAdmin\" >Cara Akses phpMyAdmin di DirectAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-export-backup-database-mysql-di-directadmin\/#Cara_Export_Database_MySQL_via_phpMyAdmin\" >Cara Export Database MySQL via phpMyAdmin<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-export-backup-database-mysql-di-directadmin\/#Penutup\" >Penutup<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>Daftar Isi<\/strong><\/p>\n<ol>\n<li><a href=\"#intro\">Intro<\/a><\/li>\n<li><a href=\"#backup-mysql-simple-directadmin\">Cara Backup Database di DirectAdmin (Cara Mudah)<\/a><\/li>\n<li><a href=\"#export-phpmyadmin\">Export Database MySQL Melalui phpMyAdmin<\/a>\n<ul>\n<li><a href=\"#akses-phpmyadmin\">Cara Akses phpMyAdmin di DirectAdmin<\/a><\/li>\n<li><a href=\"#cara-export-mysql-directadmin\">Cara Export Database MySQL via phpMyAdmin<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#penutup\">Penutup<\/a><\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Intro\"><\/span><a id=\"intro\"><\/a>Intro<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Bagi Orbiters yang menggunakan DirectAdmin panel, melakukan backup MySQL akan sangat mudah. Pada postingan kali ini kita akan membahas metode <em>export<\/em> database MySQL di DirectAdmin, dengan fitur panel maupun melalui phpMyAdmin. Simak tutorialnya berikut ini.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cara_Backup_Database_di_DirectAdmin_dengan_Mudah\"><\/span><a id=\"backup-mysql-simple-directadmin\"><\/a>Cara Backup Database di DirectAdmin dengan Mudah<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Salah satu kelebihan panel DirectAdmin adalah proses <em>backup<\/em> manual database MySQL begitu mudah, tinggal sekali klik. Berikut caranya:<\/p>\n<ol>\n<li>Login ke <strong>DirectAdmin<\/strong>, buka menu <strong>MySQL Management<br \/>\n<img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-1793\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql1.jpg\" alt=\"\" width=\"794\" height=\"170\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql1.jpg 794w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql1-300x64.jpg 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql1-768x164.jpg 768w\" sizes=\"(max-width: 794px) 100vw, 794px\" \/><br \/>\n<\/strong><\/li>\n<li>Pada database, klik <strong>Download<\/strong> untuk mengunduh backup.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-1789\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql0.jpg\" alt=\"\" width=\"874\" height=\"121\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql0.jpg 874w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql0-300x42.jpg 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql0-768x106.jpg 768w\" sizes=\"(max-width: 874px) 100vw, 874px\" \/><br \/>\n<strong>Note<\/strong>: format yang terunduh adalah <strong>.gz<\/strong> (terkompresi), bisa di-extract menjadi file berekstensi .sql.<\/li>\n<\/ol>\n<p>Selain cara mudah ini, Orbiters juga bisa melakukan export database MySQL melalui phpMyAdmin. Ini diperlukan untuk beberapa <em>custom task<\/em> yang hanya bisa dikerjakan melalui phpMyAdmin, misal mengunduh sebagian tabel saja, mengekspor database menjadi ekstensi lain, dan sebagainya. Berikut tutorialnya.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Export_Database_MySQL_Melalui_phpMyAdmin\"><\/span><a id=\"export-phpmyadmin\"><\/a>Export Database MySQL Melalui phpMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Pada panel hosting lainnya, export database lewat phpMyAdmin merupakan cara yang lazim digunakan. Fitur-fitur yang berkaitan dengan SQL bisa dengan mudah dijalankan didalamnya. DirectAdmin juga menyediakan akses phpMyAdmin untuk kemudahan dan kustomisasi database sesuai kebutuhan Orbiters.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cara_Akses_phpMyAdmin_di_DirectAdmin\"><\/span><a id=\"akses-phpmyadmin\"><\/a>Cara Akses phpMyAdmin di DirectAdmin<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Masih pada menu <strong>MySQL Management<\/strong><\/li>\n<li>Klik <strong>Login<\/strong> di bagian kanan di baris daftar database.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-1792\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql2.jpg\" alt=\"\" width=\"865\" height=\"124\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql2.jpg 865w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql2-300x43.jpg 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql2-768x110.jpg 768w\" sizes=\"(max-width: 865px) 100vw, 865px\" \/><\/li>\n<li>Halaman phpMyAdmin sukses terbuka, nama database bisa dilihat di panel kiri.<\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"Cara_Export_Database_MySQL_via_phpMyAdmin\"><\/span><a id=\"cara-export-mysql-directadmin\"><\/a>Cara Export Database MySQL via phpMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol>\n<li>Klik <strong>nama database<\/strong> yang hendak di-<em>export<\/em>, lalu klik <strong>Export\/Ekspor<\/strong> yang ada di tab atas.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1791\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql3.jpg\" alt=\"\" width=\"743\" height=\"147\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql3.jpg 743w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql3-300x59.jpg 300w\" sizes=\"(max-width: 743px) 100vw, 743px\" \/><\/li>\n<li>Pilih metode ekspor, secara default mode <strong>Cepat<\/strong> dengan format SQL.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1790\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql4.jpg\" alt=\"\" width=\"608\" height=\"394\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql4.jpg 608w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/exportmysql4-300x194.jpg 300w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/li>\n<li>Tekan <strong>Kirim<\/strong>. Maka proses download backup database akan berjalan.<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Penutup\"><\/span><a id=\"penutup\"><\/a>Penutup<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Melakukan backup database rutin secara mandiri sangat penting karena data website sewaktu-waktu bisa rusak karena berbagai sebab. Walaupun JetOrbit sudah melakukan backup rutin, namun tidak ada salahnya untuk menyimpan backup secara mandiri.<\/p>\n<p>Hosting DirectAdmin di JetOrbit bisa mendapatkan potongan hingga 30% dengan membayar menggunakan OVO (promo terbatas). JetOrbit menggunakan teknologi server terbaik guna memberikan performa yang memuaskan bagi Orbiters.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Daftar Isi Intro Cara Backup Database di DirectAdmin (Cara Mudah) Export Database MySQL Melalui phpMyAdmin Cara Akses phpMyAdmin di DirectAdmin Cara Export Database MySQL via phpMyAdmin Penutup Intro Bagi Orbiters yang menggunakan DirectAdmin panel, melakukan backup MySQL akan sangat mudah. Pada postingan kali ini kita akan membahas metode export database MySQL di DirectAdmin, dengan fitur [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":1795,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[150],"tags":[254,253],"class_list":["post-1786","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-directadmin","tag-backup-database-directadmin","tag-export-mysql-directadmin"],"_links":{"self":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/1786","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/comments?post=1786"}],"version-history":[{"count":2,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/1786\/revisions"}],"predecessor-version":[{"id":5785,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/1786\/revisions\/5785"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media\/1795"}],"wp:attachment":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media?parent=1786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/categories?post=1786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/tags?post=1786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}