{"id":2593,"date":"2020-03-26T23:32:16","date_gmt":"2020-03-26T16:32:16","guid":{"rendered":"https:\/\/www.puskomedia.id\/bantuan\/?post_type=kb&#038;p=2593"},"modified":"2020-04-10T00:13:35","modified_gmt":"2020-04-09T17:13:35","slug":"cara-ekspor-dan-import-database-di-phpmyadmin","status":"publish","type":"kb","link":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/","title":{"rendered":"Cara Ekspor dan Import Database di PHPMyAdmin"},"content":{"rendered":"<h3>Cara Ekspor Database<\/h3>\n<p>1. Pertama, login dahulu ke dalam DirectAdmin. Jika anda bingung bagaimana cara login ke DirectAdmin, kami sudah membuatkan tutorialnya, di <a href=\"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-masuk-hosting-directadmin-melalui-dashboard-mitra-puskomedia\/\">https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-masuk-hosting-directadmin-melalui-dashboard-mitra-puskomedia\/<\/a>.<\/p>\n<p>2. Jika sudah masuk, anda akan melihat tampilan seperti di bawah ini, Pilih dan tekan MySQL management.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2874 size-large\" src=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/1-1024x521.png\" alt=\"\" width=\"1024\" height=\"521\" srcset=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/1-1024x521.png 1024w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/1-300x153.png 300w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/1-768x391.png 768w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/1-1080x549.png 1080w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/1.png 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>3. Setelah Masuk, tekan tombol phpmyadmin seperti gambar di bawah ini.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2879\" src=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/2-1024x521.png\" alt=\"\" width=\"1024\" height=\"521\" srcset=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/2-1024x521.png 1024w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/2-300x153.png 300w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/2-768x391.png 768w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/2-1080x549.png 1080w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/2.png 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>4. Jika sudah masuk phpmyadmin, silahkan pilih dan tekan database yang akan digunakan.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2881\" src=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/3-1024x522.png\" alt=\"\" width=\"1024\" height=\"522\" srcset=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/3-1024x522.png 1024w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/3-300x153.png 300w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/3-768x391.png 768w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/3-1080x550.png 1080w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/3.png 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>5. Untuk Export, tekan menu export (Jika sudah membuat database \/ sudah import database) lalu tekan <strong>&#8220;Go&#8221;<\/strong> maka database akan langsung terunduh.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-3060\" src=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/7-1024x486.png\" alt=\"\" width=\"1024\" height=\"486\" srcset=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/7-1024x486.png 1024w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/7-300x142.png 300w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/7-768x364.png 768w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/7-1080x512.png 1080w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/7.png 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2887\" src=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/8-1024x521.png\" alt=\"\" width=\"1024\" height=\"521\" srcset=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/8-1024x521.png 1024w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/8-300x153.png 300w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/8-768x391.png 768w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/8-1080x549.png 1080w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/8.png 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<h3>Cara Import Database<\/h3>\n<p>1. Caranya hampir sama dengan Ekspor, beda nya hanya saat setelah memilih database yang akan digunakan tekan menu import, kemudian pilih file dengan menekan tombol <strong>&#8220;Choose File&#8221;<\/strong> pilih database yang ingin anda import.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3067 size-large\" src=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/9-1024x522.png\" alt=\"\" width=\"1024\" height=\"522\" srcset=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/9-1024x522.png 1024w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/9-300x153.png 300w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/9-768x392.png 768w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/9-1080x551.png 1080w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/9.png 1365w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>2. Jika sudah lanjut dengan menekan tombol <strong>&#8220;Go&#8221;\u00a0<\/strong>di bagian bawah seperti pada gambar berikut.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2883\" src=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/5-1024x521.png\" alt=\"\" width=\"1024\" height=\"521\" srcset=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/5-1024x521.png 1024w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/5-300x153.png 300w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/5-768x391.png 768w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/5-1080x549.png 1080w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/5.png 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>3. Jika berhasil akan seperti gambar berikut ini.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2885\" src=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/6-1-1024x523.png\" alt=\"\" width=\"1024\" height=\"523\" srcset=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/6-1-1024x523.png 1024w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/6-1-300x153.png 300w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/6-1-768x392.png 768w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/6-1-1080x552.png 1080w, https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/6-1.png 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara Ekspor Database 1. Pertama, login dahulu ke dalam DirectAdmin. Jika anda bingung bagaimana cara login ke DirectAdmin, kami sudah membuatkan tutorialnya, di https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-masuk-hosting-directadmin-melalui-dashboard-mitra-puskomedia\/. 2. Jika sudah masuk, anda akan melihat tampilan seperti di bawah ini, Pilih dan tekan MySQL management.3. Setelah Masuk, tekan tombol phpmyadmin seperti gambar di bawah ini.4. Jika sudah masuk phpmyadmin, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"kbtopic":[98],"kbtag":[],"class_list":["post-2593","kb","type-kb","status-publish","hentry","kbtopic-hosting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cara Ekspor dan Import Database di PHPMyAdmin - PuskoMedia Indonesia<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Ekspor dan Import Database di PHPMyAdmin - PuskoMedia Indonesia\" \/>\n<meta property=\"og:description\" content=\"Cara Ekspor Database 1. Pertama, login dahulu ke dalam DirectAdmin. Jika anda bingung bagaimana cara login ke DirectAdmin, kami sudah membuatkan tutorialnya, di https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-masuk-hosting-directadmin-melalui-dashboard-mitra-puskomedia\/. 2. Jika sudah masuk, anda akan melihat tampilan seperti di bawah ini, Pilih dan tekan MySQL management.3. Setelah Masuk, tekan tombol phpmyadmin seperti gambar di bawah ini.4. Jika sudah masuk phpmyadmin, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"PuskoMedia Indonesia\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-09T17:13:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/1-1024x521.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-ekspor-dan-import-database-di-phpmyadmin\\\/\",\"url\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-ekspor-dan-import-database-di-phpmyadmin\\\/\",\"name\":\"Cara Ekspor dan Import Database di PHPMyAdmin - PuskoMedia Indonesia\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-ekspor-dan-import-database-di-phpmyadmin\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-ekspor-dan-import-database-di-phpmyadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/1-1024x521.png\",\"datePublished\":\"2020-03-26T16:32:16+00:00\",\"dateModified\":\"2020-04-09T17:13:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-ekspor-dan-import-database-di-phpmyadmin\\\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-ekspor-dan-import-database-di-phpmyadmin\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-ekspor-dan-import-database-di-phpmyadmin\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/1-1024x521.png\",\"contentUrl\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/1-1024x521.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/kb\\\/cara-ekspor-dan-import-database-di-phpmyadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Ekspor dan Import Database di PHPMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/#website\",\"url\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/\",\"name\":\"PuskoMedia Indonesia\",\"description\":\"Mendunia Makin Mudah\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.puskomedia.id\\\/bantuan\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Ekspor dan Import Database di PHPMyAdmin - PuskoMedia Indonesia","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Ekspor dan Import Database di PHPMyAdmin - PuskoMedia Indonesia","og_description":"Cara Ekspor Database 1. Pertama, login dahulu ke dalam DirectAdmin. Jika anda bingung bagaimana cara login ke DirectAdmin, kami sudah membuatkan tutorialnya, di https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-masuk-hosting-directadmin-melalui-dashboard-mitra-puskomedia\/. 2. Jika sudah masuk, anda akan melihat tampilan seperti di bawah ini, Pilih dan tekan MySQL management.3. Setelah Masuk, tekan tombol phpmyadmin seperti gambar di bawah ini.4. Jika sudah masuk phpmyadmin, [&hellip;]","og_url":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/","og_site_name":"PuskoMedia Indonesia","article_modified_time":"2020-04-09T17:13:35+00:00","og_image":[{"url":"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/1-1024x521.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/","url":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/","name":"Cara Ekspor dan Import Database di PHPMyAdmin - PuskoMedia Indonesia","isPartOf":{"@id":"https:\/\/www.puskomedia.id\/bantuan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/1-1024x521.png","datePublished":"2020-03-26T16:32:16+00:00","dateModified":"2020-04-09T17:13:35+00:00","breadcrumb":{"@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/#primaryimage","url":"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/1-1024x521.png","contentUrl":"https:\/\/www.puskomedia.id\/bantuan\/wp-content\/uploads\/2020\/03\/1-1024x521.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.puskomedia.id\/bantuan\/kb\/cara-ekspor-dan-import-database-di-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.puskomedia.id\/bantuan\/"},{"@type":"ListItem","position":2,"name":"Cara Ekspor dan Import Database di PHPMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/www.puskomedia.id\/bantuan\/#website","url":"https:\/\/www.puskomedia.id\/bantuan\/","name":"PuskoMedia Indonesia","description":"Mendunia Makin Mudah","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.puskomedia.id\/bantuan\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"}]}},"_links":{"self":[{"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kb\/2593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/comments?post=2593"}],"version-history":[{"count":4,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kb\/2593\/revisions"}],"predecessor-version":[{"id":3068,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kb\/2593\/revisions\/3068"}],"wp:attachment":[{"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/media?parent=2593"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kbtopic?post=2593"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.puskomedia.id\/bantuan\/wp-json\/wp\/v2\/kbtag?post=2593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}