{"id":502,"date":"2021-12-12T13:13:47","date_gmt":"2021-12-12T13:13:47","guid":{"rendered":"https:\/\/blog.hostinger.io\/id\/support\/2021\/12\/12\/1884149-bagaimana-cara-impor-database-dengan-phpmyadmin-di-hostinger\/"},"modified":"2026-05-09T09:43:21","modified_gmt":"2026-05-09T09:43:21","slug":"1884149-bagaimana-cara-impor-database-dengan-phpmyadmin-di-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/id\/support\/1884149-bagaimana-cara-impor-database-dengan-phpmyadmin-di-hostinger\/","title":{"rendered":"Bagaimana Cara Impor Database dengan PhpMyAdmin di Hostinger?"},"content":{"rendered":"<p class=\"no-margin\">Untuk mengimpor database, <b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4553791-bagaimana-cara-mengakses-phpmyadmin-di-hpanel\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">buka database melalui phpMyAdmin<\/a><\/b>.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Di phpMyAdmin, database akan dipilih secara default. Jadi, yang perlu dilakukan adalah 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\/12\/ef1b6ae4-9a9d-41fc-8ff8-bb306d54dbd0.jpg\" data-media-id=\"2095\" alt=\"phpMyAdmin: menu Impor database di panel atas disorot merah\"><\/div><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Pilih file dalam format .sql atau .sql.zip:<\/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\/12\/2ba0da30-b50b-40e5-839e-939300f49da5.jpg\" data-media-id=\"2096\" alt=\"phpMyAdmin: tombol Choose file untuk impor database, dengan opsi unggah file\"><\/div><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Jangan ubah apa pun di pengaturan dan klik <b>Go<\/b>.<\/p><p class=\"no-margin\">\n<\/p><h1 id=\"h_97c46d8610\">Kendala yang mungkin terjadi saat mengimpor database<\/h1><h2 id=\"h_1c80d4be44\">Ukuran database terlalu besar<\/h2><p class=\"no-margin\">Ukuran maksimum database yang boleh diunggah melalui phpMyAdmin adalah 256 MB. Apabila ukuran file database lebih besar dari batasan yang ditetapkan, impor database <b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4553938-bagaimana-cara-mengimpor-database-melalui-ssh\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">melalui SSH<\/a><\/b>.<\/p><p class=\"no-margin\">\n<\/p><h2 id=\"h_9cbd532183\">Format parameter salah<\/h2><p class=\"no-margin\">Pada saat mengimpor database, pastikan format filenya adalah <b>.sql<\/b>. File .sql juga dapat diimpor menggunakan tipe kompresi ini: gzip, bzip, zip (misalnya, <b>file.sql.zip<\/b>). Kesalahan ini mengindikasikan bahwa ada file database yang rusak.<\/p><p class=\"no-margin\">\n<\/p><h2 id=\"h_80f080292e\">Command ditolak user<\/h2><p class=\"no-margin\">Munculnya error ini berarti <b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4726002-bagaimana-cara-mengubah-permission-atau-hak-akses-user-database\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">user database tidak punya izin untuk mengimpor database<\/a><\/b>.<\/p><p class=\"no-margin\">\n<\/p><h2 id=\"h_8c981260e4\">Akses ditolak. Anda membutuhkan akses SUPER untuk melakukan operasi ini.<\/h2><p class=\"no-margin\">Error ini disebabkan karena database menyertakan query yang mengharuskan hak akses SUPER dijalankan. Cek kembali file .sql jika query tersebut bisa dihapus. Setelah query dihapus menggunakan text editor, impor database dapat dilakukan.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Jika query diperlukan, kemungkinan besar Anda harus berlangganan salah satu <b><a href=\"https:\/\/www.hostinger.co.id\/hosting-vps\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">paket VPS hosting<\/a><\/b>.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Selesai! Kini Anda sudah tahu cara mengimpor database MySQL.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>CATATAN:<\/b><\/p><ul>\n<li>\n<p class=\"no-margin\">Pastikan database <b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4554122-bagaimana-cara-menghapus-semua-tabel-database-di-phpmyadmin\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">sudah kosong<\/a><\/b> sebelum mengimpor backup database baru.<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4553938-bagaimana-cara-mengimpor-database-melalui-ssh\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Bagaimana cara mengimpor database melalui SSH?<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Mengimpor database melalui phpMyAdmin menggunakan hPanel<\/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":[218],"tags":[],"class_list":["post-502","post","type-post","status-publish","format-standard","hentry","category-mengimpor-database"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/1884149-how-to-import-a-database-with-phpmyadmin-in-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/1884149-como-importar-una-base-de-datos-con-phpmyadmin-en-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/1884149-bagaimana-cara-impor-database-dengan-phpmyadmin-di-hostinger\/","default":0},{"locale":"lt-LT","link":"https:\/\/www.hostinger.com\/lt\/support\/1884149-kaip-importuoti-duomenu-baze-per-phpmyadmin-hostinger-platformoje\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/1884149-como-importar-um-banco-de-dados-com-o-phpmyadmin-no-hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/502","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=502"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/502\/revisions"}],"predecessor-version":[{"id":2100,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/502\/revisions\/2100"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/media?parent=502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/categories?post=502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/tags?post=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}