{"id":359,"date":"2021-11-12T09:51:42","date_gmt":"2021-11-12T09:51:42","guid":{"rendered":"https:\/\/blog.hostinger.io\/id\/support\/2021\/11\/12\/4548519-bagaimana-cara-impor-database-menggunakan-phpmyadmin-di-cpanel-at-hostinger\/"},"modified":"2025-08-26T20:07:43","modified_gmt":"2025-08-26T20:07:43","slug":"4548519-bagaimana-cara-impor-database-menggunakan-phpmyadmin-di-cpanel-at-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/id\/support\/4548519-bagaimana-cara-impor-database-menggunakan-phpmyadmin-di-cpanel-at-hostinger\/","title":{"rendered":"Bagaimana Cara Impor Database Menggunakan phpMyAdmin di cPanel at Hostinger"},"content":{"rendered":"<p class=\"no-margin\">Jika Anda memiliki file database dalam format <b>.sql<\/b> atau <b>.sql.zip<\/b> dan ingin mengimpornya ke hosting cPanel Anda, <b><a href=\"\/id\/support\/4548523-bagaimana-cara-mengakses-phpmyadmin-di-cpanel\" target=\"_blank\" class=\"intercom-content-link\">buka phpMyAdmin<\/a><\/b> terlebih dahulu. Selanjutnya, pilih database yang Anda inginkan dan klik <b>Import<\/b> :<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2021\/11\/47a287d0-13e4-4b9f-a6c2-b0e5f49055f8.jpg\"><\/div><p class=\"no-margin\">Pilih file dari perangkat lokal Anda:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2021\/11\/ceca3853-fb59-4fa7-9049-5e2ee5476f99.jpg\"><\/div><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Lanjutkan lebih jauh tanpa mengubah apapun pada pengaturan dan klik <b>Go<\/b> .<\/p><div class=\"intercom-interblocks-callout\" style=\"background-color: #e3e7fa80;border-color: #334bfa33\">\n<p class=\"no-margin\">Ukuran maksimum database yang dapat diunggah melalui phpMyAdmin adalah <b>128 MB<\/b>. Jika file database Anda lebih besar dari itu, Anda dapat <b><a href=\"\/id\/support\/4664722\" target=\"_blank\" class=\"intercom-content-link\">mengimpornya melalui SSH<\/a><\/b>.<\/p>\n<\/div><p class=\"no-margin\">\n<\/p><h1 id=\"h_66dc2ac29c\">Kesalahan Umum<\/h1><p class=\"no-margin\">Berikut adalah beberapa kesalahan yang mungkin muncul selama proses impor dan cara memperbaikinya: <\/p><p class=\"no-margin\">\n<\/p><h2 id=\"h_a23926cd7d\"><b>Kesalahan parameter format (Incorrect format parameter)<\/b><\/h2><p class=\"no-margin\">Pastikan format file Anda adalah <b>.sql<\/b> . Sebagai alternatif, Anda dapat mengimpor database terkompresi dengan format berikut: gzip, bzip2, dan zip (misalnya, <b>database.sql.zip<\/b> ).<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Jika Anda telah memeriksa dan format file sudah benar, kesalahan ini mungkin juga menunjukkan file database yang rusak.<\/p><p class=\"no-margin\">\n<\/p><h2 id=\"h_df6de389ac\">Perintah tidak diizinkan untuk user (Command denied to user)<\/h2><p class=\"no-margin\">Jika Anda melihat kesalahan ini, berarti pengguna database Anda tidak memiliki izin yang diperlukan untuk mengimpor database. Untuk memperbaikinya, buka cPanel Anda dan buka <b>MySQL Databases<\/b> &rarr; Pengguna Anda &rarr; <b>Manage user privileges<\/b>. Verifikasi bahwa izin disetel dengan benar &ndash; secara default, semua tanda centang harus ditambahkan:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2021\/11\/f133cf97-5afa-4c9b-8f0b-f61e430b1dc6.jpg\" width=\"550\"><\/div><p class=\"no-margin\">\n<\/p><h2 id=\"h_c9c2c2acc4\">Akses ditolak. Anda harus memiliki hak akses SUPER untuk mengoperasikannya<\/h2><p class=\"no-margin\">Dalam bahasa Inggris, kesalahan ini disebut <b>Access is denied. You need the SUPER privilege for this operation<\/b>.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Kesalahan ini berarti database Anda menyertakan kueri yang memerlukan hak istimewa SUPER untuk dijalankan. Dalam hal ini, periksa kembali sifat kueri pada file <b>.sql<\/b> Anda dan hapus jika memungkinkan menggunakan editor teks pilihan Anda. Selanjutnya, coba impor database lagi.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Jika kueri yang memerlukan hak istimewa SUPER diperlukan, Anda dapat mempertimbangkan untuk menggunakan salah satu <b><a href=\"https:\/\/www.hostinger.co.id\/hosting-vps\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">layanan VPS<\/a><\/b> kami .<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Itu dia! Sekarang kamu sudah tahu cara import database MySQL di cPanel &#128522;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mengimpor database via phpMyAdmin menggunakan cPanel di Hostinger<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[170],"tags":[],"class_list":["post-359","post","type-post","status-publish","format-standard","hentry","category-mysql"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4548519-how-to-import-a-database-with-phpmyadmin-on-cpanel-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4548519-como-importar-una-base-de-datos-con-phpmyadmin-en-cpanel-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4548519-comment-importer-une-base-de-donnees-avec-phpmyadmin-sur-cpanel\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4548519-bagaimana-cara-impor-database-menggunakan-phpmyadmin-di-cpanel-at-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4548519-como-importar-um-banco-de-dados-com-o-phpmyadmin-no-cpanel\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/comments?post=359"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/359\/revisions"}],"predecessor-version":[{"id":2328,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/359\/revisions\/2328"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/media?parent=359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/categories?post=359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/tags?post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}