{"id":1778,"date":"2020-03-22T07:38:15","date_gmt":"2020-03-22T07:38:15","guid":{"rendered":"https:\/\/www.jetorbit.com\/panduan\/?p=1778"},"modified":"2020-10-16T10:22:11","modified_gmt":"2020-10-16T03:22:11","slug":"cara-restore-import-database-mysql-di-directadmin","status":"publish","type":"post","link":"https:\/\/www.jetorbit.com\/panduan\/cara-restore-import-database-mysql-di-directadmin\/","title":{"rendered":"Cara Restore\/Import 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-restore-import-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-restore-import-database-mysql-di-directadmin\/#Cara_Mengakses_phpMyAdmin_Untuk_Import_Database_MySQL\" >Cara Mengakses phpMyAdmin Untuk Import Database MySQL<\/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-restore-import-database-mysql-di-directadmin\/#Selanjutnya_Orbiters_perlu_import_file_database_via_phpMyAdmin_berikut_caranya\" >Selanjutnya, Orbiters perlu import file database via phpMyAdmin, berikut caranya:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-restore-import-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=\"#akses-phpmyadmin\">Cara Akses phpMyAdmin Untuk Import MySQL<\/a><\/li>\n<li><a href=\"#importing-mysql-phpmyadmin\">Cara Import Database via phpMyAdmin<\/a><\/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>Import database MySQL adalah proses upload database yang tersimpan di komputer lokal ke hosting. Hal ini sangat mudah dilakukan dengan memanfaatkan phpMyAdmin, sebuah software manajemen database MySQL. Hosting DirectAdmin di JetOrbit sudah tersedia software ini.<\/p>\n<p>Sebelumnya, Orbiters membutuhkan sebuah database baru untuk tindakan ini. Bila belum membuatnya, ikuti tutorial <a href=\"https:\/\/www.jetorbit.com\/panduan\/cara-membuat-database-mysql-di-directadmin\/\">cara membuat database MySQL di DirectAdmin<\/a> pada link ini.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cara_Mengakses_phpMyAdmin_Untuk_Import_Database_MySQL\"><\/span><a id=\"akses-phpmyadmin\"><\/a>Cara Mengakses phpMyAdmin Untuk Import Database MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\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-1783\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql1.jpg\" alt=\"\" width=\"791\" height=\"177\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql1.jpg 791w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql1-300x67.jpg 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql1-768x172.jpg 768w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><br \/>\n<\/strong><\/li>\n<li>Pada baris database yang ingin dilakukan import, klik <strong>Login<\/strong>.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-1782\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql2.jpg\" alt=\"\" width=\"965\" height=\"109\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql2.jpg 965w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql2-300x34.jpg 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql2-768x87.jpg 768w\" sizes=\"(max-width: 965px) 100vw, 965px\" \/><\/li>\n<li>Halaman <strong>phpMyAdmin<\/strong> sukses terbuka<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Selanjutnya_Orbiters_perlu_import_file_database_via_phpMyAdmin_berikut_caranya\"><\/span><a id=\"importing-mysql-phpmyadmin\"><\/a>Selanjutnya, Orbiters perlu import file database via phpMyAdmin, berikut caranya:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li>Klik <strong>nama database<\/strong> di panel kiri. Kemudian klik <strong>Import<\/strong> pada tab atas.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-1781\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql3.jpg\" alt=\"\" width=\"931\" height=\"157\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql3.jpg 931w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql3-300x51.jpg 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql3-768x130.jpg 768w\" sizes=\"(max-width: 931px) 100vw, 931px\" \/><\/li>\n<li>Klik tombol <strong>Telusuri<\/strong> dan pilih database yang hendak di-<em>restore<\/em> dari komputer lokal. Klik <strong>Kirim<\/strong> untuk memulai proses.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1780\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql4.jpg\" alt=\"\" width=\"602\" height=\"857\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql4.jpg 602w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql4-211x300.jpg 211w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/li>\n<li>Pesan sukses bahwa <strong>import database berhasil<\/strong> akan muncul<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1779\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2020\/03\/importmysql5.jpg\" alt=\"\" width=\"273\" height=\"45\"><\/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>Bila melakukan import database MySQL, pastikan database tersebut kosong, atau tidak ada tabel yang sama. Selain itu, beberapa hal bisa menyebabkan kegagalan import database, misal beda versi MySQL, beda charset, dan sebagainya. Bila Orbiters mengalaminya, hubungi kami segera agar ditemukan sebab dan solusinya.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Daftar Isi Intro Cara Akses phpMyAdmin Untuk Import MySQL Cara Import Database via phpMyAdmin Penutup Intro Import database MySQL adalah proses upload database yang tersimpan di komputer lokal ke hosting. Hal ini sangat mudah dilakukan dengan memanfaatkan phpMyAdmin, sebuah software manajemen database MySQL. Hosting DirectAdmin di JetOrbit sudah tersedia software ini. Sebelumnya, Orbiters membutuhkan sebuah [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":2809,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[150],"tags":[252,251],"class_list":["post-1778","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-directadmin","tag-import-database-phpmyadmin-directadmin","tag-import-mysql-directadmin"],"_links":{"self":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/1778","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=1778"}],"version-history":[{"count":2,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/1778\/revisions"}],"predecessor-version":[{"id":5781,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/1778\/revisions\/5781"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media\/2809"}],"wp:attachment":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media?parent=1778"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/categories?post=1778"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/tags?post=1778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}