{"id":3382,"date":"2016-01-19T05:41:19","date_gmt":"2016-01-19T05:41:19","guid":{"rendered":"http:\/\/www.rumahweb.com\/journal\/?p=3382"},"modified":"2022-02-18T16:28:35","modified_gmt":"2022-02-18T09:28:35","slug":"memperbaiki-dan-optimalisasi-database-dari-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/memperbaiki-dan-optimalisasi-database-dari-phpmyadmin\/","title":{"rendered":"Memperbaiki dan Optimalisasi Database dari phpMyAdmin"},"content":{"rendered":"\n

Pada panduan kali ini, Rumahweb akan memberikan cara perbaikan dan optimalisasi database MySQL melalui phpMyAdmin. Panduan ini sangat bermanfaat, bagi Anda yang mengalami database corrupt dan optimasi database. <\/p>\n\n\n\n\n\n

Rusaknya (tabel) database bisa menyebabkan website tidak dapat diakses. Sedangkan tabel dengan “beban” (overhead) yang terlalu besar akan menyebabkan website lebih berat diakses. Ada 2 hal yang bisa Anda lakukan, yaitu dengan cara memperbaiki table databasenya terlebih dahulu, lalu melakukan optimalisasi table database Anda.<\/p>\n\n\n\n

Memperbaiki dan Optimalisasi Database cPanel<\/h2>\n\n\n\n

Langkah pertama, Anda bisa login ke cPanel terlebih dahulul. Panduan login ke cPanel bisa Anda pelajari pada link : Login cPanel<\/a><\/p>\n\n\n\n

Setelah login ke cPanel, silahkan klik menu “phpMyAdmin” sesuai gambar di bawah ini:<\/p>\n\n\n\n

\"akses<\/a><\/figure><\/div>\n\n\n\n

Memperbaiki Database<\/h3>\n\n\n\n

Setelah dari halaman phpMyAdmin, silahkan menuju database yang akan diperbaiki dan atau dioptimalisasi. <\/p>\n\n\n\n

Contoh di bawah ini akan melakukan perbaikan dan optimalisasi pada database dodong_wp866. Klik tepat pada nama database yang akan diperbaiki.<\/p>\n\n\n\n

\"melihat<\/a><\/figure><\/div>\n\n\n\n

Kadangkala kita mendapati banyak database dalam hosting dan kebingungan database manakah yang digunakan oleh website yang kita gunakan. Untuk ini tidak ada salahnya mempelajari panduan pengecekan nama dabatase yang digunakan oleh website berbasis CMS WordPress<\/a> atau Joomla<\/a> lebih dahulu.<\/p>\n\n\n\n

\"melakukan<\/a><\/figure><\/div>\n\n\n\n

Selanjutnya akan muncul daftar tabel yang ada di database tersebut. Contoh di atas merupakan database yang ada di instalasi WordPress. Silahkan scroll ke bagian  bawah halaman. Kita dapat melakukan perbaikan per tabel atau keseluruhan tabel di dalam database. Untuk panduan ini, perbaikan dilakukan untuk keseluruhan database. Centang opsi “Pilih Semua” dan di drop down yang ada di sebelahnya, pilih opsi “Perbaiki tabel”.<\/p>\n\n\n\n

Optimalisasi Database<\/h3>\n\n\n\n

Langkah selanjutnya adalah melakukan optimasi tabel. Mirip dengan langkah sebelumnya, centang opsi “Pilih Semua” dan di drop down yang ada di sebelahnya, pilih opsi “Optimalkan tabel”.<\/p>\n\n\n\n

\"melakukan<\/a><\/figure><\/div>\n\n\n\n

Sampai tahap ini, proses perbaikan dan optimalisasi database telah selesai. Selanjutnya Anda bisa mencoba akses kembali nama domain Anda. <\/p>\n\n\n\n

Demikian panduan perbaikan dan optimalisasi database melalui phpMyAdmin dari Rumahweb, semoga bermanfaat. <\/p>\n","protected":false},"excerpt":{"rendered":"

Pada panduan kali ini, Rumahweb akan memberikan cara perbaikan dan optimalisasi database MySQL melalui phpMyAdmin. Panduan ini sangat bermanfaat, bagi Anda yang mengalami database corrupt dan optimasi database. Rusaknya (tabel) database bisa menyebabkan website tidak dapat diakses. Sedangkan tabel dengan “beban” (overhead) yang terlalu besar akan menyebabkan website lebih berat diakses. Ada 2 hal yang bisa […]<\/p>\n","protected":false},"author":325,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[142],"tags":[1566,134,121],"class_list":["post-3382","post","type-post","status-publish","format-standard","category-tips-dan-trik","tag-cpanel-tutorials","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\n","aioseo_head_json":{"title":"Memperbaiki dan Optimalisasi Database dari phpMyAdmin","description":"Berikut adalah panduan untuk melakukan perbaikan dan optimalisasi database MySQL melalui phpMyAdmin. Setelah login ke cPanel, Anda bisa mengklik phpMyAdmin.","canonical_url":"https:\/\/www.rumahweb.com\/journal\/memperbaiki-dan-optimalisasi-database-dari-phpmyadmin\/","robots":"max-image-preview:large","keywords":"optimalisasi database,cara optimalisasi database,cara optimasi database,optimasi database,cara memperbaiki database,memperbaiki database,cpanel tutorials,mysql,phpmyadmin","webmasterTools":{"google-site-verification":"wPstUwU5246IbK_1PqwGrc1LoSDnB-9rPbcT8_vSNgQ","miscellaneous":""},"schema":null,"og:locale":"id_Id","og:site_name":"Rumahweb Journal \u2013 News, Article, and Tutorial of Web Dev","og:type":"article","og:title":"Memperbaiki dan Optimalisasi Database dari phpMyAdmin","og:description":"Berikut adalah panduan untuk melakukan perbaikan dan optimalisasi database MySQL melalui phpMyAdmin. Setelah login ke cPanel, Anda bisa mengklik phpMyAdmin.","og:url":"https:\/\/www.rumahweb.com\/journal\/memperbaiki-dan-optimalisasi-database-dari-phpmyadmin\/","article:published_time":"2016-01-19T05:41:19+00:00","article:modified_time":"2022-02-18T09:28:35+00:00","article:publisher":"https:\/\/www.facebook.com\/RumahwebIndonesia\/","twitter:card":"summary_large_image","twitter:site":"@rumahwebtweet","twitter:title":"Memperbaiki dan Optimalisasi Database dari phpMyAdmin","twitter:description":"Berikut adalah panduan untuk melakukan perbaikan dan optimalisasi database MySQL melalui phpMyAdmin. Setelah login ke cPanel, Anda bisa mengklik phpMyAdmin.","twitter:creator":"@rumahwebtweet"},"aioseo_meta_data":{"post_id":"3382","title":null,"description":"Berikut adalah panduan untuk melakukan perbaikan dan  optimalisasi database MySQL melalui phpMyAdmin. Setelah login ke cPanel, Anda bisa mengklik phpMyAdmin.","keywords":[{"label":"optimalisasi database","value":"optimalisasi database"},{"label":" cara optimalisasi database","value":" cara optimalisasi database"},{"label":" cara optimasi database","value":" cara optimasi database"},{"label":" optimasi database","value":" optimasi database"},{"label":" cara memperbaiki database","value":" cara memperbaiki database"},{"label":" memperbaiki database","value":" memperbaiki database"}],"keyphrases":{"focus":{"keyphrase":"optimalisasi database","score":100,"analysis":{"keyphraseInTitle":{"title":"Focus keyphrase in SEO title","description":"Focus keyphrase found in SEO title.","score":9,"maxScore":9,"error":0},"keyphraseInDescription":{"title":"Focus keyphrase in meta description","description":"Focus keyphrase found in meta description.","score":9,"maxScore":9,"error":0},"keyphraseLength":{"title":"Focus keyphrase length","description":"Good job!","score":9,"maxScore":9,"error":0,"length":2},"keyphraseInURL":{"title":"Focus keyphrase in URL","description":"Focus keyphrase used in the URL.","score":5,"maxScore":5,"error":0},"keyphraseInIntroduction":{"title":"Focus keyphrase in introduction","description":"Your Focus keyphrase appears in the first paragraph. Well done!","score":9,"maxScore":9,"error":0},"keyphraseInSubHeadings":{"title":"Focus keyphrase in Subheadings","description":"Your H2 and H3 subheadings reflects the topic of your copy. Good job!","score":9,"maxScore":9,"error":0},"keyphraseInImageAlt":{"title":"Focus keyphrase in image alt attributes","description":"Focus keyphrase found in image alt attribute(s).","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":"","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":"2020-12-21 10:50:05","updated":"2026-04-19 03:06:51","seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/3382","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\/325"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=3382"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/3382\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=3382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=3382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=3382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}