How do I remove database tables?

Before importing a new database or restoring a backup, we recommend removing, or dropping, existing tables from a database. Simply follow the instructions outlined below:

Please note: this service is only available with Managed WordPress plans purchased after May 2021.

Step 1 of 5

Start by logging in to your phpMyAdmin account. For details on how to do this, please read our Support article: How do I access phpMyAdmin through WordPress?

 

Step 2 of 5

Once you’ve accessed phpMyAdmin, select Databases.

Select Databases

 

Step 3 of 5

Choose the database you wish to optimise from the list of provided options.

Choose relevant database

 

Step 4 of 5

You will now be given the complete list of tables within your database. Check the tables you wish to optimise individually or by selecting Check All at the end of the page.

Once done, select the With selected: menu alongside it and choose Drop from the drop-down menu that appears.

Drop tables

 

Step 5 of 5

You’ll receive a pop-up window that asks ‘Do you really want to execute the following query?’

Select Yes to continue.

 

Related Support Material:

  1. How to remove excessive inodes
  2. How do I remove a domain from a profile?
  3. How do I find my database hostname?
  4. How do I import a MySQL database with SSH?
  5. How do I update the database password within my configuration file?
  6. How do I resolve ‘Error establishing a database connection’?