{"id":2624,"date":"2021-10-08T22:44:42","date_gmt":"2021-10-08T22:44:42","guid":{"rendered":"https:\/\/anymhost.id\/?p=2624"},"modified":"2022-11-09T16:00:36","modified_gmt":"2022-11-09T16:00:36","slug":"cara-backup-database-mysql","status":"publish","type":"post","link":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/","title":{"rendered":"Cara Backup Database Mysql Melalui PHPMyAdmin"},"content":{"rendered":"<p><strong>PHPMyAdmin\u00a0<\/strong>merupakan salah satu\u00a0<em>tools\u00a0<\/em>administrasi database MySQL. Tool ini sangat mudah digunakan dalam mengelola database. Bila Kamu menggunakan XAMPP, PHPMyAdmin sudah tersedia dalam paket instalasi XAMPP. Disebagian besar penyedia hosting pun, PHPMyAdmin sudah tersedia, jadi Kamu tidak perlu ragu untuk menggunakan <em>tool<\/em>\u00a0ini.<\/p>\n<p>Untuk melakukan\u00a0<strong>backup atau export database<\/strong> menggunakan PHPMyAdmin berikut langkah-langkahnya<\/p>\n<p>Pertama kamu bisa masuk ke phpmyadmin melalui panel hosting yang digunakan, kemudian pilihlah database yang akan di <em>backup<\/em>.<\/p>\n<p>Misal pada contoh berikut database yang akan di backup bernama\u00a0<code>belajar_db<\/code>. Selanjutnya pilih menu\u00a0<strong>Export<\/strong>\u00a0dan tentukan format database yang di backup, misal format\u00a0<strong>SQL<\/strong>. Setelah itu klik tombol\u00a0<strong>Go\u00a0<\/strong>untuk melakukan\u00a0<em>backup<\/em>.<\/p>\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-5361\" src=\"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/cara-backup-database-mysql-menggunakan-phpmyadmin.webp\" alt=\"\" width=\"730\" height=\"486\" srcset=\"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/cara-backup-database-mysql-menggunakan-phpmyadmin.webp 730w, https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/cara-backup-database-mysql-menggunakan-phpmyadmin-300x200.webp 300w\" sizes=\"(max-width: 730px) 100vw, 730px\" \/><\/figure>\n<p>Tunggu beberapa saat hingga proses eksport database selesai. Apabila selesai akan muncul file dengan ektensi\u00a0<code>.sql<\/code><\/p>\n<p>Nah itulah cara mudah untuk backup database, kalian bisa menyimpan backup tersebut di tempat yang aman untuk mencegah kehilangan data penting.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PHPMyAdmin\u00a0merupakan salah satu\u00a0tools\u00a0administrasi database MySQL. Tool ini sangat mudah digunakan dalam mengelola database. Bila Kamu menggunakan XAMPP, PHPMyAdmin sudah tersedia dalam paket instalasi XAMPP. Disebagian besar penyedia hosting pun, PHPMyAdmin sudah tersedia, jadi Kamu tidak perlu ragu untuk menggunakan tool\u00a0ini. Untuk melakukan\u00a0backup atau export database menggunakan PHPMyAdmin berikut langkah-langkahnya Pertama kamu bisa masuk ke phpmyadmin [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5362,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83],"tags":[77,78],"class_list":["post-2624","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-panduan","tag-database","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.1.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Backup Database Mysql Melalui PHPMyAdmin - AnymHost<\/title>\n<meta name=\"description\" content=\"PHPMyAdmin\u00a0merupakan salah satu\u00a0tools\u00a0administrasi database MySQL. Tool ini sangat mudah digunakan dalam mengelola database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Backup Database Mysql Melalui PHPMyAdmin - AnymHost\" \/>\n<meta property=\"og:description\" content=\"PHPMyAdmin\u00a0merupakan salah satu\u00a0tools\u00a0administrasi database MySQL. Tool ini sangat mudah digunakan dalam mengelola database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"AnymHost\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/anymhost\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anymhost\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-08T22:44:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-09T16:00:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/Cara-Backup-Database-Mysql-Melalui-PHPMyAdmin.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"AnymHost\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"AnymHost\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/\"},\"author\":{\"name\":\"AnymHost\",\"@id\":\"https:\/\/anymhost.id\/blog\/#\/schema\/person\/4a673b7412cc2b184046c4ef470d5515\"},\"headline\":\"Cara Backup Database Mysql Melalui PHPMyAdmin\",\"datePublished\":\"2021-10-08T22:44:42+00:00\",\"dateModified\":\"2022-11-09T16:00:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/\"},\"wordCount\":146,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/anymhost.id\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/Cara-Backup-Database-Mysql-Melalui-PHPMyAdmin.webp\",\"keywords\":[\"database\",\"mysql\"],\"articleSection\":[\"Panduan\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/\",\"url\":\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/\",\"name\":\"Cara Backup Database Mysql Melalui PHPMyAdmin - AnymHost\",\"isPartOf\":{\"@id\":\"https:\/\/anymhost.id\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/Cara-Backup-Database-Mysql-Melalui-PHPMyAdmin.webp\",\"datePublished\":\"2021-10-08T22:44:42+00:00\",\"dateModified\":\"2022-11-09T16:00:36+00:00\",\"description\":\"PHPMyAdmin\u00a0merupakan salah satu\u00a0tools\u00a0administrasi database MySQL. Tool ini sangat mudah digunakan dalam mengelola database.\",\"breadcrumb\":{\"@id\":\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#primaryimage\",\"url\":\"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/Cara-Backup-Database-Mysql-Melalui-PHPMyAdmin.webp\",\"contentUrl\":\"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/Cara-Backup-Database-Mysql-Melalui-PHPMyAdmin.webp\",\"width\":900,\"height\":350},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/anymhost.id\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Backup Database Mysql Melalui PHPMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/anymhost.id\/blog\/#website\",\"url\":\"https:\/\/anymhost.id\/blog\/\",\"name\":\"AnymHost\",\"description\":\"Artikel Tips &amp; Berita Website Terbaru\",\"publisher\":{\"@id\":\"https:\/\/anymhost.id\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/anymhost.id\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/anymhost.id\/blog\/#organization\",\"name\":\"AnymHost\",\"url\":\"https:\/\/anymhost.id\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/anymhost.id\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2022\/11\/anymhost-6-min.png\",\"contentUrl\":\"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2022\/11\/anymhost-6-min.png\",\"width\":540,\"height\":540,\"caption\":\"AnymHost\"},\"image\":{\"@id\":\"https:\/\/anymhost.id\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/anymhost\",\"https:\/\/instagram.com\/anymhost\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/anymhost.id\/blog\/#\/schema\/person\/4a673b7412cc2b184046c4ef470d5515\",\"name\":\"AnymHost\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/anymhost.id\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f591cd1539c8864b0f288fce80e26362d56b0c69e4a6b34c4a123822212a57be?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f591cd1539c8864b0f288fce80e26362d56b0c69e4a6b34c4a123822212a57be?s=96&d=identicon&r=g\",\"caption\":\"AnymHost\"},\"description\":\"Dapatkan tutorial seputar website dan server disini supaya kamu tidak perlu bingung lagi. Jangan lupa kasih Feedback untuk Tutorialnya biar kita bisa berikan yang terbaik khusus buat Kamu\",\"sameAs\":[\"https:\/\/anymhost.id\/\",\"https:\/\/www.facebook.com\/anymhost\",\"https:\/\/www.instagram.com\/anymhost\/\"],\"url\":\"https:\/\/anymhost.id\/blog\/author\/anymhost\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Backup Database Mysql Melalui PHPMyAdmin - AnymHost","description":"PHPMyAdmin\u00a0merupakan salah satu\u00a0tools\u00a0administrasi database MySQL. Tool ini sangat mudah digunakan dalam mengelola database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Cara Backup Database Mysql Melalui PHPMyAdmin - AnymHost","og_description":"PHPMyAdmin\u00a0merupakan salah satu\u00a0tools\u00a0administrasi database MySQL. Tool ini sangat mudah digunakan dalam mengelola database.","og_url":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/","og_site_name":"AnymHost","article_publisher":"https:\/\/www.facebook.com\/anymhost","article_author":"https:\/\/www.facebook.com\/anymhost","article_published_time":"2021-10-08T22:44:42+00:00","article_modified_time":"2022-11-09T16:00:36+00:00","og_image":[{"width":900,"height":350,"url":"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/Cara-Backup-Database-Mysql-Melalui-PHPMyAdmin.webp","type":"image\/webp"}],"author":"AnymHost","twitter_card":"summary_large_image","twitter_misc":{"Written by":"AnymHost","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#article","isPartOf":{"@id":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/"},"author":{"name":"AnymHost","@id":"https:\/\/anymhost.id\/blog\/#\/schema\/person\/4a673b7412cc2b184046c4ef470d5515"},"headline":"Cara Backup Database Mysql Melalui PHPMyAdmin","datePublished":"2021-10-08T22:44:42+00:00","dateModified":"2022-11-09T16:00:36+00:00","mainEntityOfPage":{"@id":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/"},"wordCount":146,"commentCount":0,"publisher":{"@id":"https:\/\/anymhost.id\/blog\/#organization"},"image":{"@id":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/Cara-Backup-Database-Mysql-Melalui-PHPMyAdmin.webp","keywords":["database","mysql"],"articleSection":["Panduan"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/","url":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/","name":"Cara Backup Database Mysql Melalui PHPMyAdmin - AnymHost","isPartOf":{"@id":"https:\/\/anymhost.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#primaryimage"},"image":{"@id":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/Cara-Backup-Database-Mysql-Melalui-PHPMyAdmin.webp","datePublished":"2021-10-08T22:44:42+00:00","dateModified":"2022-11-09T16:00:36+00:00","description":"PHPMyAdmin\u00a0merupakan salah satu\u00a0tools\u00a0administrasi database MySQL. Tool ini sangat mudah digunakan dalam mengelola database.","breadcrumb":{"@id":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#primaryimage","url":"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/Cara-Backup-Database-Mysql-Melalui-PHPMyAdmin.webp","contentUrl":"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2021\/10\/Cara-Backup-Database-Mysql-Melalui-PHPMyAdmin.webp","width":900,"height":350},{"@type":"BreadcrumbList","@id":"https:\/\/anymhost.id\/blog\/cara-backup-database-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/anymhost.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Cara Backup Database Mysql Melalui PHPMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/anymhost.id\/blog\/#website","url":"https:\/\/anymhost.id\/blog\/","name":"AnymHost","description":"Artikel Tips &amp; Berita Website Terbaru","publisher":{"@id":"https:\/\/anymhost.id\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/anymhost.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/anymhost.id\/blog\/#organization","name":"AnymHost","url":"https:\/\/anymhost.id\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/anymhost.id\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2022\/11\/anymhost-6-min.png","contentUrl":"https:\/\/anymhost.id\/blog\/wp-content\/uploads\/2022\/11\/anymhost-6-min.png","width":540,"height":540,"caption":"AnymHost"},"image":{"@id":"https:\/\/anymhost.id\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/anymhost","https:\/\/instagram.com\/anymhost"]},{"@type":"Person","@id":"https:\/\/anymhost.id\/blog\/#\/schema\/person\/4a673b7412cc2b184046c4ef470d5515","name":"AnymHost","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/anymhost.id\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f591cd1539c8864b0f288fce80e26362d56b0c69e4a6b34c4a123822212a57be?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f591cd1539c8864b0f288fce80e26362d56b0c69e4a6b34c4a123822212a57be?s=96&d=identicon&r=g","caption":"AnymHost"},"description":"Dapatkan tutorial seputar website dan server disini supaya kamu tidak perlu bingung lagi. Jangan lupa kasih Feedback untuk Tutorialnya biar kita bisa berikan yang terbaik khusus buat Kamu","sameAs":["https:\/\/anymhost.id\/","https:\/\/www.facebook.com\/anymhost","https:\/\/www.instagram.com\/anymhost\/"],"url":"https:\/\/anymhost.id\/blog\/author\/anymhost\/"}]}},"_links":{"self":[{"href":"https:\/\/anymhost.id\/blog\/wp-json\/wp\/v2\/posts\/2624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anymhost.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anymhost.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anymhost.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anymhost.id\/blog\/wp-json\/wp\/v2\/comments?post=2624"}],"version-history":[{"count":0,"href":"https:\/\/anymhost.id\/blog\/wp-json\/wp\/v2\/posts\/2624\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/anymhost.id\/blog\/wp-json\/wp\/v2\/media\/5362"}],"wp:attachment":[{"href":"https:\/\/anymhost.id\/blog\/wp-json\/wp\/v2\/media?parent=2624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anymhost.id\/blog\/wp-json\/wp\/v2\/categories?post=2624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anymhost.id\/blog\/wp-json\/wp\/v2\/tags?post=2624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}