{"id":2602,"date":"2025-11-13T13:23:27","date_gmt":"2025-11-13T06:23:27","guid":{"rendered":"https:\/\/www.jagoweb.com\/kb\/?post_type=ht_kb&#038;p=2602"},"modified":"2025-11-13T13:23:27","modified_gmt":"2025-11-13T06:23:27","slug":"mengimpor-database-mysql-melalui-command-line-ssh","status":"publish","type":"ht_kb","link":"https:\/\/www.jagoweb.com\/kb\/knowledge-base-jagoweb\/mengimpor-database-mysql-melalui-command-line-ssh\/","title":{"rendered":"Mengimpor Database MySQL Melalui Command Line SSH"},"content":{"rendered":"<p>Selain menggunakan phpMyAdmin, Anda juga dapat melakukan import database MySQL melalui command line SSH. Metode ini merupakan salah satu cara paling efisien untuk mengelola file dan database di akun hosting Anda. Dengan beberapa perintah sederhana, Anda bisa mengimpor file database MySQL ke dalam database yang sudah tersedia.<\/p>\n<p>Sebelum melakukan proses import, pastikan Anda telah mengekspor database menjadi file berekstensi <strong>.sql<\/strong> atau format serupa.<\/p>\n<p>Berikut langkah-langkah untuk mengimpor database MySQL melalui command line SSH:<\/p>\n<ol>\n<li><strong>Upload file .sql<\/strong> yang akan diimpor ke server menggunakan <strong>FileZilla<\/strong> atau <strong>File Manager<\/strong> di cPanel.<\/li>\n<li><strong>Buat database baru<\/strong> di cPanel Anda.<\/li>\n<li><strong>Login ke server melalui SSH<\/strong>, lalu arahkan ke direktori tempat Anda mengunggah file .sql tadi.<\/li>\n<li>Jalankan perintah berikut:<\/li>\n<\/ol>\n<p><strong>mysql -p -u username-cpanel databases_name &lt; file-databases.sql<\/strong><\/p>\n<p>Keterangan:<\/p>\n<ul>\n<li><strong>username-cpanel<\/strong> : Username akun cPanel Anda<\/li>\n<li><strong>databases_name<\/strong> : Nama database tujuan<\/li>\n<li><strong>file-databases.sql<\/strong> : Nama file database yang akan diimpor<\/li>\n<\/ul>\n<p>Setelah menjalankan perintah tersebut, sistem akan meminta <strong>password cPanel<\/strong> Anda. Masukkan password tersebut untuk melanjutkan proses import.<\/p>\n<p>Jika langkah-langkah di atas sudah dilakukan dengan benar, proses import database melalui Command Line SSH telah selesai.<\/p>\n<p><strong>Catatan:<\/strong><br \/>\nMetode ini hanya dapat digunakan pada layanan hosting yang memiliki akses SSH.<\/p>\n<p>Apabila Anda mengalami kendala dalam melakukan import database melalui Command Line SSH, silakan hubungi tim teknis <a href=\"https:\/\/www.jagoweb.com\/\"><strong>Jagoweb<\/strong><\/a> untuk mendapatkan bantuan.<\/p>\n","protected":false},"author":7,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":[],"ht_kb_category":[107],"ht_kb_tag":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb\/2602"}],"collection":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/comments?post=2602"}],"version-history":[{"count":2,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb\/2602\/revisions"}],"predecessor-version":[{"id":2604,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb\/2602\/revisions\/2604"}],"wp:attachment":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/media?parent=2602"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb_category?post=2602"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb_tag?post=2602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}