{"id":19521,"date":"2021-03-16T20:26:59","date_gmt":"2021-03-16T13:26:59","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=19521"},"modified":"2022-04-27T10:59:57","modified_gmt":"2022-04-27T03:59:57","slug":"cara-import-database-ssh","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/cara-import-database-ssh\/","title":{"rendered":"Cara Import Database Melalui Terminal (SSH) di Hosting"},"content":{"rendered":"\n<p>Ada dua cara yang bisa Anda lakukan, untuk mengimport database ke hosting. Yaitu melalui phpMyAdmin dan Terminal (SSH). Untuk <strong>cara import database<\/strong> melalui phpMyAdmin, panduannya bisa Anda pelajari melalui link <a href=\"https:\/\/www.rumahweb.com\/journal\/cara-upload-mysql-database\/\" title=\"https:\/\/www.rumahweb.com\/journal\/cara-import-database-mysql-phpmyadmin\/\" target=\"_blank\" rel=\"noreferrer noopener\">Cara import database phpMyAdmin<\/a> .<\/p>\n\n\n\n\n\n<p>Import database melalui phpMyAdmin memiliki keterbatasan, yaitu tidak bisa melakukan import file lebih dari 50MB. Karena itu, bila file database yang akan Anda import memiliki size lebih dari 50MB, maka solusinya bisa menggunakan terminal atau SSH di hosting.<\/p>\n\n\n\n<p>Bagi Anda pengguna layanan <a href=\"https:\/\/www.rumahweb.com\/hosting-murah\/\">hosting murah<\/a> paket Medium dan Large atau Cloud Hosting, kini Anda sudah bisa mengakses terminal SSH untuk kebutuhan import database maupun hal lainnya. Panduan SSH di hosting bisa Anda pelajari melalui link : <a href=\"https:\/\/www.rumahweb.com\/journal\/menggunakan-ssh-pada-layanan-hosting-rumahweb\/\">cara SSH di hosting<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cara Import Database dengan SSH<\/h2>\n\n\n\n<p>Berikut Cara Import Database Melalui Terminal (SSH) pada Hosting :<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Membuat database dan user database<\/h3>\n\n\n\n<p>Sebelum melakukan import database, silahkan membuat lebih dulu database dan user database. Panduannya bisa dilihat di <a href=\"https:\/\/www.rumahweb.com\/journal\/membuat-database-di-account-hosting\/\" target=\"_blank\" rel=\"noreferrer noopener\">Membuat Database di Account Hosting<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Upload database<\/h3>\n\n\n\n<p>Upload database dengan format sql ke hosting, proses upload bisa melalui &#8220;File Manager&#8221; di cPanel atau FTP.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. Melakukan Import Database Melalui Terminal (SSH)<\/h3>\n\n\n\n<p>Langkah pertama, silahkan Anda login ke akun cPanel hostingnya. Setelah itu, silahkan ikuti panduan berikut : <\/p>\n\n\n\n<p>1. Masuk menu &#8220;Terminal&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/terminal-cPanel.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"528\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/terminal-cPanel-1024x528.png\" alt=\"terminal cPanel - Cara Import Database Melalui Terminal (SSH) pada Hosting\" class=\"wp-image-19524\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/terminal-cPanel-1024x528.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/terminal-cPanel-300x155.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/terminal-cPanel-768x396.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/terminal-cPanel-370x191.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/terminal-cPanel-270x139.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/terminal-cPanel-570x294.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/terminal-cPanel-740x381.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/terminal-cPanel.png 1337w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>2. Masuk ke folder tempat file sql di upload (pada contoh file sql diupload ke dalam folder &#8220;public_html&#8221; dengan nama &#8220;tenda333_db.sql&#8221;)<br \/><br \/><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"269\" class=\"wp-image-19525\" style=\"width: 600px;\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/cd-public_html.png\" alt=\"\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/cd-public_html.png 1187w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/cd-public_html-300x134.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/cd-public_html-1024x459.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/cd-public_html-768x344.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/cd-public_html-370x166.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/cd-public_html-270x121.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/cd-public_html-570x255.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/cd-public_html-740x332.png 740w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n\n\n\n<p>3. Perintah importnya adalah : <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql -u userdb -p namadb &lt; nama file yang akan di import<\/pre>\n\n\n\n<p>contoh implementasinya seperti berikut : <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql -u tenda333_userdb -p tenda333_dbweb &lt; tenda333_db.sql<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1162\" height=\"531\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/import-sql-dari-terminal.png\" alt=\"\" class=\"wp-image-19527\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/import-sql-dari-terminal.png 1162w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/import-sql-dari-terminal-300x137.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/import-sql-dari-terminal-1024x468.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/import-sql-dari-terminal-768x351.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/import-sql-dari-terminal-370x169.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/import-sql-dari-terminal-270x123.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/import-sql-dari-terminal-570x260.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/03\/import-sql-dari-terminal-740x338.png 740w\" sizes=\"auto, (max-width: 1162px) 100vw, 1162px\" \/><\/figure>\n\n\n\n<p>Pastikan mengganti : <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>tenda333_userdb = User database yang sudah dibuat dari langkah no 2<\/li><li>tenda333_dbweb = Nama database yang dibuat dari langkah no 2<\/li><li>tenda333_db.sql = Nama file sql yang diupload ke hosting<\/li><li>Password user database dimasukan setelah muncul &#8220;Enter password:&#8221;<\/li><\/ul>\n\n\n\n<p>Bagaimana, mudah bukan? Selamat mencoba. Seperti biasa, jika ada kesulitan silakan menghubungi support kami melalui live chat maupun email ke email teknis@rumahweb.com agar dilakukan pemeriksaan lebih lanjut.<\/p>\n\n\n\n<p>Demikian panduan Cara Import Database Melalui Terminal (<a href=\"https:\/\/blog.rumahweb.com\/ssh-adalah\/\" title=\"ssh adalah\">SSH<\/a>) pada Hosting. Semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ada dua cara yang bisa Anda lakukan, untuk mengimport database ke hosting. Yaitu melalui phpMyAdmin dan Terminal (SSH). Untuk cara import database melalui phpMyAdmin, panduannya bisa Anda pelajari melalui link Cara import database phpMyAdmin . Import database melalui phpMyAdmin memiliki keterbatasan, yaitu tidak bisa melakukan import file lebih dari 50MB. Karena itu, bila file database [&hellip;]<\/p>\n","protected":false},"author":324,"featured_media":19529,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[695],"tags":[1351,1370],"class_list":{"0":"post-19521","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-cpanel","8":"tag-panduan-cpanel","9":"tag-tutorial-cpanel"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/19521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/users\/324"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=19521"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/19521\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/19529"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=19521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=19521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=19521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}