{"id":334,"date":"2021-11-12T09:32:38","date_gmt":"2021-11-12T09:32:38","guid":{"rendered":"https:\/\/blog.hostinger.io\/id\/support\/2021\/11\/12\/4664722-bagaimana-cara-mengimpor-database-melalui-ssh-di-cpanel-hostinger\/"},"modified":"2021-11-12T09:32:38","modified_gmt":"2021-11-12T09:32:38","slug":"4664722-bagaimana-cara-mengimpor-database-melalui-ssh-di-cpanel-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/id\/support\/4664722-bagaimana-cara-mengimpor-database-melalui-ssh-di-cpanel-hostinger\/","title":{"rendered":"Bagaimana Cara Mengimpor Database Melalui SSH di cPanel Hostinger?"},"content":{"rendered":"<p class=\"no-margin\">Dengan phpMyAdmin, Anda bisa <b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4885818-bagaimana-cara-impor-database-menggunakan-phpmyadmin-di-cpanel\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">mengimpor database<\/a><\/b> hingga <b>128 MB<\/b> (bisa kurang jika database memiliki banyak baris). Jika terjadi kegagalan saat melakukan impor dengan phpMyAdmin, database dapat diimpor menggunakan <b>SSH<\/b>. Berikut langkah-langkahnya:<\/p><p class=\"no-margin\">\n<\/p><h1 id=\"h_5897f11e4c\">Langkah 1 &ndash; Yang Perlu Disiapkan<\/h1><ul>\n<li>\n<p class=\"no-margin\">Unggah database (file dalam format .<b>sql<\/b>) ke public_html (bisa dilakukan <b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/2232482-idh-cara-mengupload-backup-dengan-ftp\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">melalui FTP<\/a><\/b>).<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4885777-bagaimana-cara-membuat-database-mysql-baru-di-cpanel\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Buat database baru<\/a><\/b> atau <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\">bersihkan database yang akan jadi tempat impor konten baru<\/a><\/b>.<\/p>\n<\/li>\n<\/ul><h1 id=\"h_234cd54676\">Langkah 2 &ndash; Membuat Sambungan<\/h1><ul>\n<li>\n<p class=\"no-margin\">Buat sambungan ke <b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4885925-bagaimana-cara-login-ke-akun-cpanel-via-ssh\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">akun hosting melalui SSH<\/a><\/b>.<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Untuk membuka <b>direktori yang tepat<\/b> (public_html), jalankan perintah Is. Apabila saat ini Anda membuka direktori yang lain, gunakan perintah Is dan cd satu per satu. Berikut tampilan path-nya:<\/p>\n<\/li>\n<\/ul><pre><code>cd domains<br>cd domain.com (where domain.com is your domain)<br>cd public_html<\/code><\/pre><ul>\n<li>\n<p class=\"no-margin\">Jika berhasil, backup database akan ditampilkan.<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Jika file backup tidak ditampilkan, cek kembali File Manager &ndash; apakah file sudah diunggah dan ditempatkan di public_html.<\/p>\n<\/li>\n<\/ul><h1 id=\"h_6d4147e590\">Langkah 3 &ndash; Mengimpor Database<\/h1><p class=\"no-margin\">Untuk <b>mengimpor database<\/b>, gunakan perintah berikut:<\/p><p class=\"no-margin\">\n<\/p><pre><code>mysql -u database_username -p database_name &lt; file.sql<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Apabila <b>parameter database<\/b>:<\/p><ul>\n<li>\n<p class=\"no-margin\">MySQL Database name: u123456789_database<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">MySQL Username: u123456789_admin<\/p>\n<\/li>\n<\/ul><p class=\"no-margin\">Dan file yang diunggah adalah <b>database.sql<\/b>, perintahnya akan terlihat seperti ini:<\/p><p class=\"no-margin\">\n<\/p><pre><code>mysql -u u123456789_admin -p u123456789_database &lt; database.sql<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>Masukkan password database<\/b> untuk melanjutkan proses impor. Waktu impor tergantung pada ukuran database. Jika sudah selesai, baris baru akan muncul:<\/p><p class=\"no-margin\">\n<\/p><pre><code>-bash-4.2$<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Baris di atas mengindikasikan selesainya proses impor database. Tabel database akan muncul di phpMyAdmin.<\/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\"><b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4885818-bagaimana-cara-impor-database-menggunakan-phpmyadmin-di-cpanel\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Bagaimana cara impor database dengan phpMyAdmin di cPanel?<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4885720-bagaimana-cara-ekspor-database-phpmyadmin-di-cpanel\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Bagaimana cara ekspor database dengan phpMyAdmin di cPanel?<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4554083-bagaimana-cara-mengekspor-database-melalui-ssh-di-cpanel\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Bagaimana cara ekspor database melalui SSH di cPanel?<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Mengimpor database melalui SSH di cPanel<\/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-334","post","type-post","status-publish","format-standard","hentry","category-mysql"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4664722-how-to-import-a-database-over-ssh-on-cpanel-at-hostinger\/","default":1},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4664722-comment-importer-une-base-de-donnees-par-ssh-sur-cpanel-a-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4664722-bagaimana-cara-mengimpor-database-melalui-ssh-di-cpanel-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4664722-como-faco-para-importar-um-banco-de-dados-por-ssh-no-cpanel\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/334","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=334"}],"version-history":[{"count":0,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/334\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/media?parent=334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/categories?post=334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/tags?post=334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}