Deleting or dropping a table can be necessary if you want to import a backup file and need to make space. In other cases deleted plugins sometimes leave tables in your database that are no longer used. However, you need to be sure you know what you are doing before dropping a table as this can potentially break your entire site!
If you are, here is how to do it:
- In your database, mark the table or tables you want to delete via check box on the left.
- In the drop-down menu at the bottom, choose “drop”.
- You will then be taken to a confirmation screen. If you choose “yes”, the table will be delete irreversibly.
Dropping An Entire Database
You can not only drop tables one by one, but you can also get rid of a database all at once. A case where that might be neccessary is when you have moved your site to another server and no longer need the database. Of course, only drop it if you have successfully exported and imported the database to its new location.
- Click on “Databases” to view all databases in your account.
- Mark the checkbox of the database you no longer need. Double check that the tick mark is in the right place!
- At the bottom of the list, click on “Drop”. A confirmation prompt will pop up. If you press “ok”, the database in question will be history.
Copying Your Database
Making a copy of your database is a good idea if you are setting up a development environment to test out themes and plugins before introducing them to your live site. It’s done quickly within phpMyAdmin by choosing your database and going to “Operations” > “Copy database to:”.
Replacing The Table Prefix
For security’s sake,it is a good idea to use a different table prefix for your WordPress install than the default “wp_”. However, if you have forgotten to change this during the install, phpMyAdmin can help you remedy the situation by replacing “wp_” with something else via the bottom menu. Just make sure you also update wp-config.php to reflect the change.
In Short: phpMyAdmin, The WordPress User’s Best Friend.