{"id":1184,"date":"2020-10-14T13:39:41","date_gmt":"2020-10-14T13:39:41","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2020\/10\/14\/4536290-how-to-delete-all-database-tables-in-phpmyadmin-in-hostinger\/"},"modified":"2026-10-15T08:27:51","modified_gmt":"2026-10-15T08:27:51","slug":"4536290-how-to-delete-all-database-tables-in-phpmyadmin-in-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/4536290-how-to-delete-all-database-tables-in-phpmyadmin-in-hostinger\/","title":{"rendered":"How to delete all database tables in phpMyAdmin in Hostinger"},"content":{"rendered":"<p>Delete all database tables in phpMyAdmin in Hostinger to empty a database, for example before importing a fresh database backup. Select the tables, choose Drop, and confirm the action.<\/p><h2 id=\"h-delete-all-tables-from-a-database-in-phpmyadmin\">Delete all tables from a database in phpMyAdmin<\/h2><div class=\"intercom-interblocks-callout\" style=\"background-color: #feedaf80;border-color: #fbc91633\">\n<p class=\"no-margin\">Deleting database tables will <b>remove the data permanently<\/b> &ndash; proceed with caution<\/p>\n<\/div><ol>\n<li>\n<p class=\"no-margin\">Open your <b><a data-click-id=\"hgr-post-content-link-database-in-phpmyadmin\" class=\"intercom-content-link\" href=\"https:\/\/www.hostinger.com\/support\/1583545-how-to-access-phpmyadmin-at-hostinger\/\" target=\"_blank\" rel=\"noopener\">database in phpMyAdmin<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Check the boxes near tables you wish to delete, or use the <b>Check all<\/b> checkbox to select all tables and click on <b>Drop<\/b> from the drop-down list:<br>\n<img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/de074477-5c19-45bd-8d97-1baaebd20fd2.jpg\" alt=\"phpMyAdmin bulk actions menu with the Drop option highlighted after Check all tables selected\" data-media-id=\"4633\"><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Confirm the action:<br>\n<img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/05b00ac7-f224-41e5-ac88-373c44bdeaed.jpg\" alt=\"phpMyAdmin confirmation dialog with the Yes button highlighted to execute a DROP TABLE query\" data-media-id=\"4634\"><\/p>\n<\/li>\n<\/ol><p class=\"no-margin\">Your database is now empty and ready for you to import fresh content.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Delete all database tables in phpMyAdmin in Hostinger: select the tables, choose Drop, and confirm to empty a database before an import.<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[244],"tags":[],"class_list":["post-1184","post","type-post","status-publish","format-standard","hentry","category-phpmyadmin"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4536290-how-to-delete-all-database-tables-in-phpmyadmin-in-hostinger","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4536290-como-eliminar-todas-las-tablas-de-la-base-de-datos-en-phpmyadmin-en-hostinger","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4536290-comment-supprimer-toutes-les-tables-de-la-base-de-donnees-dans-phpmyadmin-chez-hostinger","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4536290-bagaimana-cara-menghapus-semua-tabel-database-di-phpmyadmin-di-hostinger","default":0},{"locale":"pt-BR","link":"https:\/\/www.hostinger.com\/br\/support\/4536290-como-excluir-todas-as-tabelas-do-banco-de-dados-no-phpmyadmin-hostinger","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/4536290-\u044f\u043a-\u0432\u0438\u0434\u0430\u043b\u0438\u0442\u0438-\u0432\u0441\u0456-\u0442\u0430\u0431\u043b\u0438\u0446\u0456-\u0431\u0430\u0437\u0438-\u0434\u0430\u043d\u0438\u0445-\u0443-phpmy","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=1184"}],"version-history":[{"count":3,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1184\/revisions"}],"predecessor-version":[{"id":20722,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1184\/revisions\/20722"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}