{"id":33691,"date":"2016-09-18T17:05:50","date_gmt":"2016-09-18T17:05:50","guid":{"rendered":"https:\/\/hostduplex.com\/kb\/?p=52"},"modified":"2016-09-18T17:05:50","modified_gmt":"2016-09-18T17:05:50","slug":"how-to-optimize-the-database-via-phpmyadmin-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.hostduplex.com\/kb\/how-to-optimize-the-database-via-phpmyadmin-in-cpanel\/","title":{"rendered":"How to optimize the database via phpMyAdmin in cPanel?"},"content":{"rendered":"<p><span style=\"font-size: medium;\"><strong>1.<\/strong> Log into your cPanel account.<\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>2.<\/strong> In the <strong>Databases<\/strong> section, click on the <\/span><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><strong>phpMyAdmin<\/strong><\/span><\/span> icon.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-icon.gif\" alt=\"\" align=\"middle\" \/><\/span><\/p>\n<p><span style=\"font-size: medium;\"><br \/>\n<\/span><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><strong>3.<\/strong> In left side-bar, Click on the expand button to expand the database like &#8220;example&#8221;. <\/span><\/span><br \/>\n<span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-expand-db.gif\" alt=\"\" align=\"left\" \/><\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><strong>4.<\/strong> Under your cPanel username, you can see a list of all databases. Select the appropriate database which you want to optimize.<\/span><\/span><br \/>\n<span style=\"font-size: medium;\"><img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-db-list.gif\" alt=\"\" \/><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>5. <\/strong>Scroll down and mark <\/span><span style=\"font-size: medium;\"><strong>Check All<\/strong> then click on the Drop-down option and select <strong>Optimize tables<\/strong>.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/optimize-db.gif\" alt=\"\" \/><\/span><\/p>\n<p>Table successfully optimized.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like &#8220;example&#8221;. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4. Under your cPanel username, you can see a list of all databases. Select&#8230;<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[57],"tags":[],"class_list":["post-33691","post","type-post","status-publish","format-standard","hentry","category-databases"],"_links":{"self":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts\/33691","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/comments?post=33691"}],"version-history":[{"count":0,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts\/33691\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/media?parent=33691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/categories?post=33691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/tags?post=33691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}