{"id":31,"date":"2023-11-29T04:12:19","date_gmt":"2023-11-29T04:12:19","guid":{"rendered":"https:\/\/blog.hostinger.io\/id\/support\/2023\/11\/29\/8649834-cara-import-database-dengan-bigdump-di-hostinger\/"},"modified":"2025-08-26T19:54:40","modified_gmt":"2025-08-26T19:54:40","slug":"8649834-cara-import-database-dengan-bigdump-di-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/id\/support\/8649834-cara-import-database-dengan-bigdump-di-hostinger\/","title":{"rendered":"Cara Import Database dengan BigDump di Hostinger"},"content":{"rendered":"<p class=\"no-margin\"><b>BigDump<\/b> adalah file yang berisi skrip dengan perintah bahasa pemrograman PHP. Itulah mengapa file ini berekstensi .php. Di dalam file tersebut terdapat perintah untuk melakukan import database MySQL.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Seseorang ingin import database melalui phpMyAdmin, tetapi gagal karena ukuran file database yang besar. Solusi pertama, Anda dapat coba<b> <a href=\"\/id\/support\/4536306-bagaimana-cara-mengimpor-database-melalui-ssh\" target=\"_blank\" class=\"intercom-content-link\">import database melalui SSH<\/a><\/b>. Namun, terdapat paket hosting yang tidak menyediakan fitur SSH pada cPanel.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Dengan BigDump, Anda juga dapat melakukan import database MySQL. Akan tetapi, sesuaikan dulu skrip berdasarkan credential database Anda, seperti db_server, db_name, db_user, dan db_password.<\/p><p class=\"no-margin\">\n<\/p><h2 id=\"h_fe86948782\">Download File BigDump<\/h2><p class=\"no-margin\">Silakan download file BigDump dengan klik URL berikut: <b><a href=\"https:\/\/www.ozerov.de\/bigdump\/\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Download BigDump<\/a><\/b>. Kemudian, lakukan <b>Extract<\/b> pada file <b>bigdump.zip<\/b>. Pastikan telah muncul file <b>bigdump.php<\/b>.<\/p><p class=\"no-margin\">\n<\/p><h2 id=\"h_14588912c3\">Upload File BigDump dan File Database SQL di public_html<\/h2><p class=\"no-margin\"><b><a href=\"\/id\/support\/4548506-bagaimana-cara-upload-backup-menggunakan-file-manager-di-cpanel\" target=\"_blank\" class=\"intercom-content-link\">Upload <\/a><\/b>2 file berikut di direktori <b>public_html<\/b> melalui File Manager:<\/p><ul>\n<li>\n<p class=\"no-margin\">File bigdump.php<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">File database.sql yang akan Anda import.<\/p>\n<\/li>\n<\/ul><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2023\/11\/98354f05-ea9c-4ff6-9454-ef3f861e4355.jpg\"><\/div><p class=\"no-margin\">\n<\/p><h2 id=\"h_c66d9095e6\">Sesuaikan Credential DB &amp; Max Query Lines pada File BigDump<\/h2><p class=\"no-margin\">Edit skrip pada file bigdump.php untuk menyesuaikan credential database dan fungsi max_query_lines.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">1. Klik kanan file <b>bigdump.php<\/b>, kemudian pilih <b>Edit<\/b>.<\/p><p class=\"no-margin\">2. Gulir skrip ke bagian <b>Database Configuration<\/b>. Sesuaikan credential database berikut:<\/p><ul>\n<li>\n<p class=\"no-margin\"><b>$db_server<\/b>: Isi dengan localhost.<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b>$db_name<\/b>: Masukkan nama database.<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b>$db_username<\/b>: Masukkan username database.<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b>$db_password<\/b>: Masukkan password database.<\/p>\n<\/li>\n<\/ul><p class=\"no-margin\">Untuk menyimpan perubahan, klik tombol <b>Save Changes<\/b>.<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2023\/11\/895df10d-4afd-4d3d-b5a5-358cd69fc75e.jpg\"><\/div><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">3. Selanjutnya, gulir ke bagian <b>$max_query_lines<\/b>. Tentukan batas maksimum baris query yang dapat diimport. Sesuaikan dengan jumlah baris pada file <b>database sql<\/b> Anda. Simpan perubahan dengan klik tombol <b>Save Changes<\/b>.<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/id\/support\/wp-content\/uploads\/sites\/57\/2023\/11\/2f6ad16d-8d37-4b0b-b701-d8b49885d779.jpg\"><\/div><p class=\"no-margin\">\n<\/p><h2 id=\"h_53e1a3604f\">Proses Import Database dengan BigDump<\/h2><p class=\"no-margin\">Selanjutnya Anda bisa mulai melakukan import database dengan BigDump.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">1. Masukkan ke URL: <b>namadomain.com\/bigdump.php<\/b> melalui web browser.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">2. Anda akan diarahkan ke halaman <b>BigDump<\/b>. Untuk memulai proses import file database sql, klik <b>Start Import<\/b>.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">3. Selamat! Database berhasil Anda import dengan BigDump. Setelah itu, Anda dapat menghapus file bigdump.php di direktori public_html melalui File Manager.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">4. Silakan masuk ke <b><a href=\"\/id\/support\/4548523-bagaimana-cara-mengakses-phpmyadmin-di-cpanel\" target=\"_blank\" class=\"intercom-content-link\">phpMyAdmin<\/a><\/b><a href=\"\/id\/support\/4548523-bagaimana-cara-mengakses-phpmyadmin-di-cpanel\" target=\"_blank\" class=\"intercom-content-link\"> <\/a>untuk memastikan database berhasil Anda import.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Import database ukuran besar dengan BigDump<\/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-31","post","type-post","status-publish","format-standard","hentry","category-mengimpor-database"],"hreflangs":[],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/31","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=31"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/31\/revisions"}],"predecessor-version":[{"id":910,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/31\/revisions\/910"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/media?parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/categories?post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/tags?post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}