How do I delete tables from my database?

Deleting tables from your database can be necessary when cleaning up or removing old installations, like WordPress. This guide will walk you through the steps to safely delete tables using phpMyAdmin.

Note: Be very careful when you work in phpMyAdmin, as it is not possible to undo changes. We recommend creating a backup, before you make any changes.


Step 1 - Click PHP and database settings in the Control Panel

  1. Log in to the one.com Control Panel.
  2. Click PHP and database settings on the Advanced settings tile.

Step 2 - Open the database in phpMyAdmin

Select the database in phpMyAdmin where you want to delete tables.

Tip: If you want to remove a WordPress installation, you can recognize the database by the WordPress icon next to the name.

Open_Database.png


Step 3 - Click Databases

In phpMyAdmin, click Databases in the menu at the top of your screen.

Database in phpMyAdmin


Step 4 - Click the database name

Click the name of the database, in this guide, it's one_example_support.

Click database


Step 5 - Drop the selected tables

  1. Select the tables you want to delete by checking the box to the left of the row.
  2. In the drop-down menu at the bottom, choose Drop.

Note: Always check the wp-config.php file in your WordPress installation directory to confirm the correct table prefix. For instance, if you installed WordPress on the subdomain "blog," the prefix might be blog_.

Select tables and choose drop in the drop down menu


Step 6 - Confirm dropping tables

Check if you are dropping the correct tables, and click Yes to confirm.

Click yes to confirm you want to drop the selected tables


Step 7 - Done!

That's all. The tables are now deleted.

Your selected tables have been dropped


Related articles:

Was this article helpful?

Can’t find what you are looking for?

Start a chat

It's the quickest way to get in touch, every day of the year.

Give us a call

Available on weekdays from 10am to 2pm (UTC).