{"id":335,"date":"2021-11-12T09:33:36","date_gmt":"2021-11-12T09:33:36","guid":{"rendered":"https:\/\/blog.hostinger.io\/id\/support\/2021\/11\/12\/4664708-bagaimana-cara-mengekspor-database-melalui-ssh-di-cpanel-di-hostinger\/"},"modified":"2021-11-12T09:33:36","modified_gmt":"2021-11-12T09:33:36","slug":"4664708-bagaimana-cara-mengekspor-database-melalui-ssh-di-cpanel-di-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/id\/support\/4664708-bagaimana-cara-mengekspor-database-melalui-ssh-di-cpanel-di-hostinger\/","title":{"rendered":"Bagaimana Cara Mengekspor Database melalui SSH di cPanel di Hostinger?"},"content":{"rendered":"<p class=\"no-margin\">Jika terjadi kegagalan saat melakukan <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\">ekspor database dengan phpMyAdmin<\/a><\/b>, database dapat diekspor menggunakan <b>SSH<\/b>. Berikut langkah-langkahnya:<\/p><p class=\"no-margin\">\n<\/p><h1 id=\"h_4b874edd51\"><b>Langkah 1 &ndash; Yang Perlu Disiapkan<\/b><\/h1><p class=\"no-margin\">Cari parameter database, termasuk password. Jika tidak tahu value password database, <b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/2338502-bagaimana-cara-memulihkan-password-mysql-saya\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">ganti dengan yang baru<\/a><\/b>.<\/p><p class=\"no-margin\">\n<\/p><h1 id=\"h_1cfc10b73b\"><b>Langkah 2 &ndash; Membuat Sambungan<\/b><\/h1><ul>\n<li>\n<p class=\"no-margin\">Buat sambungan ke <b><a href=\"https:\/\/support.hostinger.co.id\/id\/articles\/4459002-cara-login-ke-akun-melalui-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\">Pastikan Anda membuka <b>direktori yang tepat<\/b> (database akan diekspor ke direktori yang saat ini Anda gunakan). Untuk navigasi antar direktori, gunakan perintah <b>Is<\/b> dan <b>cd<\/b>.<\/p>\n<\/li>\n<\/ul><h1 id=\"h_735c368f7d\"><b>Langkah 3 &ndash; Mengekspor Database<\/b><\/h1><p class=\"no-margin\">Untuk <b>mengekspor database<\/b>, gunakan perintah berikut:<\/p><p class=\"no-margin\">\n<\/p><pre><code>mysqldump -u database_username -p database_name &gt; 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>backup.sql<\/b>, perintahnya akan terlihat seperti ini:<\/p><p class=\"no-margin\">\n<\/p><pre><code>mysqldump -u u123456789_admin -p u123456789_database &gt; backup.sql<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>Masukkan password database<\/b> untuk melanjutkan proses ekspor. Waktu ekspor 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 ekspor database. Tabel database akan muncul di File Manager.<\/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 mengimpor 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\/4553938-bagaimana-cara-mengimpor-database-melalui-ssh\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Bagaimana cara mengimpor database dengan SSH 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 mengekspor database dengan phpMyAdmin di cPanel?<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Mengekspor 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-335","post","type-post","status-publish","format-standard","hentry","category-mysql"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4664708-how-to-export-a-database-over-ssh-on-cpanel-at-hostinger\/","default":1},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4664708-comment-exporter-une-base-de-donnees-par-ssh-sur-cpanel-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4664708-bagaimana-cara-mengekspor-database-melalui-ssh-di-cpanel-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4664708-como-faco-para-exportar-um-banco-de-dados-por-ssh-no-cpanel-hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/335","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=335"}],"version-history":[{"count":0,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/335\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/media?parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/categories?post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/tags?post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}