{"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":"2025-08-27T07:09:45","modified_gmt":"2025-08-27T07:09:45","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":"

If you want to remove tables from a database – for example, before importing a fresh database backup, follow these steps:<\/p>

\n

Deleting database tables will remove the data permanently<\/b> – proceed with caution<\/p>\n<\/div>

    \n
  1. \n

    Open your database in phpMyAdmin<\/a><\/b><\/p>\n<\/li>\n

  2. \n

    Check the boxes near tables you wish to delete, or use the Check all<\/b> checkbox to select all tables and click on Drop<\/b> from the drop-down list:<\/p>\n<\/li>\n<\/ol>

    <\/div>

    Confirm the action:<\/p>

    \n<\/p>

    <\/div>

    All done! Now your database is empty, and you can proceed with importing fresh content to it 😊 <\/p>\n","protected":false},"excerpt":{"rendered":"

    Deleting the content of the database in phpMyAdmin<\/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-PT","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--------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":1,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1184\/revisions"}],"predecessor-version":[{"id":4638,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1184\/revisions\/4638"}],"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}]}}