How do I remove database tables?

Michael Jordan

4 years ago

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.

Step 3 of 5

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

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.

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.