{"id":10060,"date":"2026-07-18T13:20:22","date_gmt":"2026-07-18T06:20:22","guid":{"rendered":"https:\/\/www.jetorbit.com\/panduan\/?p=10060"},"modified":"2026-07-18T13:20:22","modified_gmt":"2026-07-18T06:20:22","slug":"cara-export-database-mysql-via-command-line","status":"publish","type":"post","link":"https:\/\/www.jetorbit.com\/panduan\/cara-export-database-mysql-via-command-line\/","title":{"rendered":"Cara Export Database MySQL via Command Line"},"content":{"rendered":"\n<p>Waktu lagi ngoprek database pernahkah kalian terpikiran \u201ckalau misalnya server ini tiba tiba error gimana nasib databasenya, kalau sampai hilang apa jadinya dengan semua data yang ada didalamnya\u201d.<\/p>\n\n\n\n<p>Nah disini pentingnya melakukan Export Database atau membuat salinan(backup).<\/p>\n\n\n\n<p>Export database akan menyimpan data mulai dari struktur tabel hingga seluruh isinya dalam file .sql. File ini bisa di import kapan saja saat dibutuhkan misalnya ketika server bermasalah ataupun migrasi system.<\/p>\n\n\n\n<p>Banyak orang masih menggunakan phpMyAdmin untuk melakukan export database, namun apabila terdapat banyak database, ukurannya besar, atau server tidak memiliki GUI cara ini akan lebih ribet. Disinilah peran penting <strong>mysqldump, <\/strong>tool bawaan mysql yang digunakan untuk export database menggunakan CLI, cara ini jauh lebih simple, cepat, dan efisien.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Persiapan:<\/strong><\/h3>\n\n\n\n<p>sebelum melakukan export pastikan:&nbsp;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Dapat mengakses server via SSH melalui Terminal atau Putty<\/li>\n\n\n\n<li>Database yang ingin diexport sudah tersedia<\/li>\n\n\n\n<li>Mengetahui user dan password MySQL<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Langkah Langkah:&nbsp;<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Exporting MySQL database.<\/strong><\/li>\n<\/ol>\n\n\n\n<p>pastikan kalian sudah login ke server via SSH, lalu jalankan perintah berikut<\/p>\n\n\n\n<p>mysqldump -u user -p namadatabase &gt; fileexport.sql<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"811\" height=\"97\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-4.png\" alt=\"\" class=\"wp-image-10061\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-4.png 811w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-4-300x36.png 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-4-768x92.png 768w\" sizes=\"(max-width: 811px) 100vw, 811px\" \/><\/figure>\n\n\n\n<p>keterangan<\/p>\n\n\n\n<p>-u : user mysql<\/p>\n\n\n\n<p>-p : memakai password (akan dimnta setelah menekan enter)<\/p>\n\n\n\n<p>nama database : nama database yang ingin di export<\/p>\n\n\n\n<p>fileexport.sql : nama file hasil export database<\/p>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Export beberapa database sekaligus\u00a0<\/strong><\/li>\n<\/ol>\n\n\n\n<p>apabila kalian ingin export beberapa database sekaligus gunakan perintah<\/p>\n\n\n\n<p>mysqldump -u user -p &#8211;databases database1 database2 database3 &gt; multiple.sql&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"42\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-6-1024x42.png\" alt=\"\" class=\"wp-image-10063\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-6-1024x42.png 1024w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-6-300x12.png 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-6-768x32.png 768w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-6.png 1185w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>Export seluruh database pada server<\/strong><\/li>\n<\/ol>\n\n\n\n<p>untuk melakukan export seluruh database pada server gunakan perintah mysqldump -u user -p &#8211;all-databases &gt; alldatabase.sql&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"932\" height=\"99\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-5.png\" alt=\"\" class=\"wp-image-10062\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-5.png 932w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-5-300x32.png 300w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-5-768x82.png 768w\" sizes=\"(max-width: 932px) 100vw, 932px\" \/><\/figure>\n\n\n\n<p>Dengan perintah perintah di atas proses backup database akan lebih cepat dan praktis tanpa klik klik manual.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Waktu lagi ngoprek database pernahkah kalian terpikiran \u201ckalau misalnya server ini tiba tiba error gimana nasib databasenya, kalau sampai hilang apa jadinya dengan semua data yang ada didalamnya\u201d. Nah disini pentingnya melakukan Export Database atau membuat salinan(backup). Export database akan menyimpan data mulai dari struktur tabel hingga seluruh isinya dalam file .sql. File ini bisa [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":2809,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-10060","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dasar"],"_links":{"self":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/10060","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/comments?post=10060"}],"version-history":[{"count":1,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/10060\/revisions"}],"predecessor-version":[{"id":10064,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/10060\/revisions\/10064"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media\/2809"}],"wp:attachment":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media?parent=10060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/categories?post=10060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/tags?post=10060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}