{"id":851,"date":"2011-05-18T19:07:10","date_gmt":"2011-05-18T19:07:10","guid":{"rendered":"http:\/\/www.rumahweb.com\/journal\/?p=851"},"modified":"2022-01-19T17:05:01","modified_gmt":"2022-01-19T10:05:01","slug":"cara-export-database-di-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/cara-export-database-di-phpmyadmin\/","title":{"rendered":"Cara Export Database di phpMyadmin cPanel"},"content":{"rendered":"\n<p>Ketika Anda bermaksud memindahkan database dari satu hosting ke hosting yang lain, atau ingin <span style=\"text-decoration: underline;\">melakukan backup database<\/span>, maka Anda perlu melakukan <strong>export database<\/strong> terlebih dahulu. Pada panduan ini, kami akan berbagi cara export database melalui phpMyAdmin di cPanel. <\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Apa itu export database?<\/h2>\n\n\n\n<p>Export database bisa diartikan melakukan backup pada database. Export database diperlukan apabila Anda ingin melakukan migrasi website dari satu server ke server lainnya. <\/p>\n\n\n\n<p>Sebagai contoh, anda telah membuat website di localhost dan ingin mengonlinekan website yang anda buat ke hosting. Salah satu langkah yang perlu anda lakukan adalah meng-export database dari localhost lalu di import ke database hosting. <\/p>\n\n\n\n<p>Ada beberapa cara yang bisa anda lakukan untuk export database mysql. Seperti dari menu Backup, phpMyAdmin hingga SSH dengan query mysql dump. Dalam panduan ini, kami akan menjelaskan pada Anda cara export database untuk pengguna cPanel hosting.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cara export database di phpMyAdmin<\/h2>\n\n\n\n<p>Berikut ini langkah-langkah untuk melakukan <strong>export database di cPanel<\/strong><\/p>\n\n\n\n<p>1. Silahkan <a href=\"https:\/\/www.rumahweb.com\/journal\/login-cpanel-hosting-melalui-clientzone\/\" title=\"Cara login cpanel\">Login ke<strong> cPanel<\/strong><\/a> hosting Anda. Setelah itu klik menu &#8220;phpMyAdmin&#8221; untuk melakukan export database di cPanel.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2011\/05\/Cara-Export-Database-dari-cPanel-e1495509277430.png\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"461\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2011\/05\/Cara-Export-Database-dari-cPanel-e1495509277430.png\" alt=\"menu phpmyadmin di cpanel\" class=\"wp-image-6066\"\/><\/a><\/figure><\/div>\n\n\n\n<p>2. Pilih database yang ingin di export pada list database.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2011\/05\/Export-Database-phpMyAdmin-via-cPanel-e1495509333803.png\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"426\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2011\/05\/Export-Database-phpMyAdmin-via-cPanel-e1495509333803.png\" alt=\"pilih database yang akan di export\" class=\"wp-image-6067\"\/><\/a><\/figure><\/div>\n\n\n\n<p>3. Pada halaman selanjutnya pilih menu &#8220;export&#8221;.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2011\/05\/How-To-Export-Database-using-cPanel-e1495509369788.png\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"285\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2011\/05\/How-To-Export-Database-using-cPanel-e1495509369788.png\" alt=\"Klik menu export database\" class=\"wp-image-6068\"\/><\/a><\/figure><\/div>\n\n\n\n<p>4. Pada pilihan export di kotak export, pastikan Anda memilih &#8220;sql&#8221;.<\/p>\n\n\n\n<p>5. Pilih save as file dan kemudian klik <strong>Go.<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2011\/05\/How-To-Export-Database-using-cPanel-phpMyAdmin-e1495509401539.png\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"420\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2011\/05\/How-To-Export-Database-using-cPanel-phpMyAdmin-e1495509401539.png\" alt=\"Cara export database di phpmyadmin cpanel\" class=\"wp-image-6069\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Untuk melakukan export ini, Anda bisa juga melakukannya melakukan custom. Misal Anda akan export untuk table tertentu saja.<\/p>\n\n\n\n<p>Demikian cara <em>export database di phpMyAdmin <\/em>melalui cPanel<em>. <\/em>Setelah berhasil di export, Anda sudah bisa memindahkan databasenya ke server lain atau sekadar backup.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ketika Anda bermaksud memindahkan database dari satu hosting ke hosting yang lain, atau ingin melakukan backup database, maka Anda perlu melakukan export database terlebih dahulu. Pada panduan ini, kami akan berbagi cara export database melalui phpMyAdmin di cPanel. Apa itu export database? Export database bisa diartikan melakukan backup pada database. Export database diperlukan apabila Anda [&hellip;]<\/p>\n","protected":false},"author":318,"featured_media":14317,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[142],"tags":[348,135,901,121],"class_list":{"0":"post-851","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-tips-dan-trik","8":"tag-backup","9":"tag-database","10":"tag-export-database","11":"tag-phpmyadmin"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2011\/05\/banner-artikel-export-database-dari-cpanel.png","jetpack_shortlink":"https:\/\/wp.me\/p8n3G7-dJ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/851","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\/318"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=851"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/851\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/14317"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}