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.

• Step 1 - Click PHP and database settings in the Control Panel
• Step 2 - Open the database in phpMyAdmin
• Step 3 - Click Databases
• Step 4 - Click the database name
• Step 5 - Drop the selected tables
• Step 6 - Confirm dropping tables
• Step 7 - Done!

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.

Step 3 - Click Databases

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

Step 4 - Click the database name

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

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_.

Step 6 - Confirm dropping tables

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

Step 7 - Done!

That's all. The tables are now deleted.

Related articles:

• How do I delete a 1-click WordPress installation?
• How do I import a database to phpMyAdmin?