{"id":532,"date":"2019-02-27T06:32:25","date_gmt":"2019-02-27T06:32:25","guid":{"rendered":"https:\/\/shujaahost.co.ke\/blog\/?p=532"},"modified":"2019-10-19T10:50:54","modified_gmt":"2019-10-19T10:50:54","slug":"dropping-database-tables-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/","title":{"rendered":"Dropping database tables in phpMyAdmin"},"content":{"rendered":"\n<p>phpMyAdmin is a powerful web interface that helps you manage MySql databases from your computer browser. Dropping database tables in phpMyAdmin is a simple task. However, caution must be taken because when you drop database tables, all the data in the table is deleted. You can learn more about phpMyAdmin <a href=\"https:\/\/phpmyadmin.net\">here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to drop a database table.<\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li><a href=\"https:\/\/shujaahost.co.ke\/clientarea\/knowledgebase.php?action=displayarticle&amp;id=4\">Log into your cPanel<\/a>.<\/li><li>Under <strong>DATABASES<\/strong> section, click on  phpMyAdmin.<\/li><li>Go to your left side of the phpMyAdmin, select the database you want to work with.<\/li><li>Inside the database you selected, you\u2019ll find list of tables appearing in the left side and the wider right side.<\/li><li>Place a check mark on the table(s) to drop (permanently delete).<\/li><li>Underneath the list of tables you\u2019ll see &#8220;<strong>With selected:<\/strong>&#8221; select &#8220;<strong>Drop<\/strong>&#8221; from this list.<\/li><li>Immediately you click it will ask you \u201cDo you really want to execute the following query?\u201d Counter check on what will be dropped to make sure it\u2019s the right table(s) you are about to drop. If it is right table(s), click on the YES Button to continue. If otherwise then click NO Button.<\/li><\/ol>\n\n\n\n<p>Dropping database tables in phpMyAdmin is not a reversible action, I strongly advice you to take a database backup before dropping your tables.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin is a powerful web interface that helps you manage MySql databases from your computer browser. Dropping database tables in phpMyAdmin is a simple task. However, caution must be taken because when you drop database tables, all the data in the table is deleted. You can learn more about phpMyAdmin here. How to drop a ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-532","post","type-post","status-publish","format-standard","hentry","category-databases"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Dropping database tables in phpMyAdmin - Shujaa Host<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dropping database tables in phpMyAdmin - Shujaa Host\" \/>\n<meta property=\"og:description\" content=\"phpMyAdmin is a powerful web interface that helps you manage MySql databases from your computer browser. Dropping database tables in phpMyAdmin is a simple task. However, caution must be taken because when you drop database tables, all the data in the table is deleted. You can learn more about phpMyAdmin here. How to drop a ..Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Shujaa Host\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/shujaahostKenya\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-27T06:32:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-19T10:50:54+00:00\" \/>\n<meta name=\"author\" content=\"Cosmas Korir\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@shujaahost_ke\" \/>\n<meta name=\"twitter:site\" content=\"@shujaahost_ke\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Cosmas Korir\" \/>\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:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/\"},\"author\":{\"name\":\"Cosmas Korir\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59\"},\"headline\":\"Dropping database tables in phpMyAdmin\",\"datePublished\":\"2019-02-27T06:32:25+00:00\",\"dateModified\":\"2019-10-19T10:50:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/\"},\"wordCount\":215,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#organization\"},\"articleSection\":[\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/\",\"name\":\"Dropping database tables in phpMyAdmin - Shujaa Host\",\"isPartOf\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#website\"},\"datePublished\":\"2019-02-27T06:32:25+00:00\",\"dateModified\":\"2019-10-19T10:50:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/shujaahost.co.ke\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dropping database tables in phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#website\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/\",\"name\":\"Shujaa Host\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/shujaahost.co.ke\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#organization\",\"name\":\"Shujaa Host\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png\",\"contentUrl\":\"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png\",\"width\":911,\"height\":770,\"caption\":\"Shujaa Host\"},\"image\":{\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/shujaahostKenya\/\",\"https:\/\/x.com\/shujaahost_ke\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59\",\"name\":\"Cosmas Korir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g\",\"caption\":\"Cosmas Korir\"},\"sameAs\":[\"https:\/\/shujaahost.co.ke\"],\"url\":\"https:\/\/shujaahost.co.ke\/blog\/author\/cosmas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dropping database tables in phpMyAdmin - Shujaa Host","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:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"Dropping database tables in phpMyAdmin - Shujaa Host","og_description":"phpMyAdmin is a powerful web interface that helps you manage MySql databases from your computer browser. Dropping database tables in phpMyAdmin is a simple task. However, caution must be taken because when you drop database tables, all the data in the table is deleted. You can learn more about phpMyAdmin here. How to drop a ..Read more","og_url":"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/","og_site_name":"Shujaa Host","article_publisher":"https:\/\/www.facebook.com\/shujaahostKenya\/","article_published_time":"2019-02-27T06:32:25+00:00","article_modified_time":"2019-10-19T10:50:54+00:00","author":"Cosmas Korir","twitter_card":"summary_large_image","twitter_creator":"@shujaahost_ke","twitter_site":"@shujaahost_ke","twitter_misc":{"Written by":"Cosmas Korir","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/"},"author":{"name":"Cosmas Korir","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59"},"headline":"Dropping database tables in phpMyAdmin","datePublished":"2019-02-27T06:32:25+00:00","dateModified":"2019-10-19T10:50:54+00:00","mainEntityOfPage":{"@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/"},"wordCount":215,"commentCount":0,"publisher":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#organization"},"articleSection":["Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/","url":"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/","name":"Dropping database tables in phpMyAdmin - Shujaa Host","isPartOf":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#website"},"datePublished":"2019-02-27T06:32:25+00:00","dateModified":"2019-10-19T10:50:54+00:00","breadcrumb":{"@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/shujaahost.co.ke\/blog\/dropping-database-tables-in-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/shujaahost.co.ke\/blog\/"},{"@type":"ListItem","position":2,"name":"Dropping database tables in phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/shujaahost.co.ke\/blog\/#website","url":"https:\/\/shujaahost.co.ke\/blog\/","name":"Shujaa Host","description":"","publisher":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/shujaahost.co.ke\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/shujaahost.co.ke\/blog\/#organization","name":"Shujaa Host","url":"https:\/\/shujaahost.co.ke\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png","contentUrl":"https:\/\/shujaahost.co.ke\/blog\/wp-content\/uploads\/2018\/10\/new-logo3-e1550211460915.png","width":911,"height":770,"caption":"Shujaa Host"},"image":{"@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/shujaahostKenya\/","https:\/\/x.com\/shujaahost_ke"]},{"@type":"Person","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/05c3cd0b767a65a164c5ed37c3edda59","name":"Cosmas Korir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/shujaahost.co.ke\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b163afca96bad97fe2edc180307eb19d?s=96&r=g","caption":"Cosmas Korir"},"sameAs":["https:\/\/shujaahost.co.ke"],"url":"https:\/\/shujaahost.co.ke\/blog\/author\/cosmas\/"}]}},"_links":{"self":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts\/532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/comments?post=532"}],"version-history":[{"count":3,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts\/532\/revisions"}],"predecessor-version":[{"id":1067,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/posts\/532\/revisions\/1067"}],"wp:attachment":[{"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/media?parent=532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/categories?post=532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shujaahost.co.ke\/blog\/wp-json\/wp\/v2\/tags?post=532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}