Announcing One-Click Restores, Disaster Recovery, and More

Want to be able to restore your site with just one click? In the newest version of Duplicator, we're launching…

How to Delete a Database or Tables using cPanel

-

The following procedures explain how to remove data from a MySQL database using standard cPanel components.

How to Delete a Database using cPanel

The following explains how to remove a database completely using the MySQL Databases cPanel component:

Login to your host’s cPanel interface (or equivalent)
Click on the MySQL Databases icon.
Scroll down to the Current Databases list.
Find the database you wish to delete and click the Delete link in the corresponding row.

The following explains how to retain a MySQL database while removing all tables using the phpMyAdmin cPanel component:

Login to your host’s cPanel interface (or equivalent).
Click on the phpMyAdmin icon.
Find the database you wish to delete on the left side of the screen and click on it.
Click on the Structure tab.
Check the Check All checkbox beneath the table list.
Click on the With Selected: dropdown and select Drop.
<The page will be refreshed with a SQL statement>
Click Yes

How to Import or Export a Database using cPanel - Snap Creek Software says:

November 11, 2016 at 2:53 pm

[…] If you don’t have a database or if you already have a database and want the existing tables removed see this article for how to create a database or remove tables. […]

Comments are closed.