{"id":24821,"date":"2021-10-06T17:08:04","date_gmt":"2021-10-06T10:08:04","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=24821"},"modified":"2023-02-20T09:17:22","modified_gmt":"2023-02-20T02:17:22","slug":"cara-backup-database-mysql-di-localhost","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/cara-backup-database-mysql-di-localhost\/","title":{"rendered":"Cara Backup Database MySQL di Localhost Komputer"},"content":{"rendered":"\n

Pada artikel ini, kami akan memberikan panduan cara backup database MySQL<\/a> di localhost komputer, agar dapat diupload ke hosting atau server yang anda gunakan. Backup database MySQL ini dilakukan dengan cara mengubah database ke dalam file SQL, sehingga nantinya dapat diupload ke server hosting. <\/p>\n\n\n\n\n\n

Ada beberapa aplikasi web server local<\/a> yang bisa anda gunakan seperti XAMPP<\/a>, WAMP Server, AMPPS, EasyPHP hingga UwAmp. Pada panduan ini, kami menggunakan softaware dari XAMPP yang merupakan aplikasi web server local terpopuler hingga saat ini. <\/p>\n\n\n\n

Cara Backup Database MySQL di Localhost<\/h2>\n\n\n\n

Melakukan backup database MySQL di localhost cukup mudah. Pastikan bahwa service Apache dan MySQL web server local anda telah aktif. Selanjutnya anda dapat mengakses halaman phpMyAdmin melalui web browser. <\/p>\n\n\n\n

Berikut cara backup database MySQL di localhost XAMPP : <\/p>\n\n\n\n

    \n
  1. Akses halaman phpMyAdmin menggunakan web browser, melalui link berikut : http:\/\/localhost\/phpmyadmin\/<\/li>\n<\/ol>\n\n\n\n
    \"Cara<\/a><\/figure>\n\n\n\n
      \n
    1. Di sebelah kiri, pilih database dengan cara di-klik pada nama database yang akan di backup atau di-export menjadi file SQL. Dalam contoh ini, kami akan membackup database dengan nama smk.<\/strong> Setelah itu klik menu Export seperti gambar berikut : <\/li>\n<\/ol>\n\n\n\n
      \"Cara<\/a><\/figure>\n\n\n\n
        \n
      1. Setelah itu akan muncul halaman export database dengan nama “smk”. Klik tombol “Go” untuk mendownload file database.sql anda.<\/li>\n<\/ol>\n\n\n\n
        \"Cara<\/a><\/figure>\n\n\n\n
          \n
        1. Selanjutnya anda hanya perlu menunggu hingga download file database.sql selesai. <\/li>\n<\/ol>\n\n\n\n
          \"Cara<\/a><\/figure>\n\n\n\n

          Setelah proses download backup database MySQL ini selesai, langkah selanjutnya adalah dapat mengupload database tersebut ke server hosting. Panduannya bisa Anda pelajari melalui artikel berikut : Cara Import Database phpMyAdmin<\/a><\/p>\n\n\n\n

          Demikian cara backup database MySQL di localhost XAMPP komputer anda. Semoga dapat membantu.<\/p>\n","protected":false},"excerpt":{"rendered":"

          Pada artikel ini, kami akan memberikan panduan cara backup database MySQL di localhost komputer, agar dapat diupload ke hosting atau server yang anda gunakan. Backup database MySQL ini dilakukan dengan cara mengubah database ke dalam file SQL, sehingga nantinya dapat diupload ke server hosting. Ada beberapa aplikasi web server local yang bisa anda gunakan seperti […]<\/p>\n","protected":false},"author":329,"featured_media":24828,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[142],"tags":[348,135,134,121],"class_list":["post-24821","post","type-post","status-publish","format-standard","has-post-thumbnail","category-tips-dan-trik","tag-backup","tag-database","tag-mysql","tag-phpmyadmin"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"Cara Backup Database MySQL di Localhost Komputer","description":"Pada artikel ini, kami akan memberikan panduan cara backup database MySQL di localhost komputer, agar dapat diupload ke hosting atau server yang anda","canonical_url":"https:\/\/www.rumahweb.com\/journal\/cara-backup-database-mysql-di-localhost\/","robots":"max-image-preview:large","keywords":"mysql backup database,cara backup database,cara backup database sql,backup database,cara backup database mysql,backup mysql database,backup database di localhost,cara backup database localhost,backup,database,mysql,phpmyadmin","webmasterTools":{"google-site-verification":"wPstUwU5246IbK_1PqwGrc1LoSDnB-9rPbcT8_vSNgQ","miscellaneous":""},"schema":null,"og:locale":"id_Id","og:site_name":"Rumahweb Journal \u2013 Panduan Website, Hosting, dan Server","og:type":"article","og:title":"Cara Backup Database MySQL di Localhost Komputer","og:description":"Pada artikel ini, kami akan memberikan panduan cara backup database MySQL di localhost komputer, agar dapat diupload ke hosting atau server yang anda","og:url":"https:\/\/www.rumahweb.com\/journal\/cara-backup-database-mysql-di-localhost\/","og:image":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/Banner-Cara-Backup-Database-MySQL-di-Localhost-Komputer.png","og:image:secure_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/Banner-Cara-Backup-Database-MySQL-di-Localhost-Komputer.png","og:image:width":740,"og:image:height":389,"article:published_time":"2021-10-06T10:08:04+00:00","article:modified_time":"2023-02-20T02:17:22+00:00","article:publisher":"https:\/\/www.facebook.com\/RumahwebIndonesia\/","twitter:card":"summary_large_image","twitter:site":"@rumahwebtweet","twitter:title":"Cara Backup Database MySQL di Localhost Komputer","twitter:description":"Pada artikel ini, kami akan memberikan panduan cara backup database MySQL di localhost komputer, agar dapat diupload ke hosting atau server yang anda","twitter:creator":"@rumahwebtweet","twitter:image":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2021\/10\/Banner-Cara-Backup-Database-MySQL-di-Localhost-Komputer.png"},"aioseo_meta_data":{"post_id":"24821","title":null,"description":"Pada artikel ini, kami akan memberikan panduan cara backup database MySQL di localhost komputer, agar dapat diupload ke hosting atau server yang anda","keywords":[{"label":"mysql backup database","value":"mysql backup database"},{"label":" cara backup database","value":" cara backup database"},{"label":" cara backup database sql","value":" cara backup database sql"},{"label":" backup database","value":" backup database"},{"label":" cara backup database mysql","value":" cara backup database mysql"},{"label":" backup mysql database","value":" backup mysql database"},{"label":" backup database di localhost","value":" backup database di localhost"},{"label":" cara backup database localhost","value":" cara backup database localhost"}],"keyphrases":{"focus":{"keyphrase":"cara backup database mysql","score":100,"analysis":{"keyphraseInTitle":{"score":9,"maxScore":9,"error":0},"keyphraseInDescription":{"score":9,"maxScore":9,"error":0},"keyphraseLength":{"score":9,"maxScore":9,"error":0,"length":4},"keyphraseInURL":{"score":5,"maxScore":5,"error":0},"keyphraseInIntroduction":{"score":9,"maxScore":9,"error":0},"keyphraseInSubHeadings":{"score":9,"maxScore":9,"error":0},"keyphraseInImageAlt":{"score":9,"maxScore":9,"error":0}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[],"defaultGraph":"Article","defaultPostTypeGraph":""},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-10-06 09:27:55","updated":"2026-04-19 04:16:42","seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/24821","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\/329"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=24821"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/24821\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/24828"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=24821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=24821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=24821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}