Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  MySQL  >  Learn to Empty a MySQL Database in Simple Steps
Top Scroll

Learn to Empty a MySQL Database in Simple Steps

 2 min

Using phpMyAdmin or SSH, you can empty the content of a MySQL database. But ensure that you take a backup of your database (phpMyAdmin or SSH) before making any changes to your databases.

Empty a MySQL Database Using phpMyAdmin

This is the easiest way to empty a MySQL database as compared to other ways.

Login to your cPanel account and go to Databses -> phpMyAdmin


Then select the database you want to empty.


You will see a list with all the database’s tables. For selecting all the tables in the database click on Check All link.


Next, select Drop from the drop down menu of “With selected:”. With this. the DROP TABLE SQL query will run on all tables and after you confirm that you wish to proceed by clicking on Go, the database will be emptied.

Empty a MySQL Database Using SSH

When you drop the content of a database using SSH, it proves to be very useful in terms large databases. For this, you need to use the drop and create privilege ( or lese you will drop the database but won’t be able to create it again).

  • Go to MySQL with your database MySQL user by executing the below command over SSH:
mysql -uUSERNAME -p

Remember to replace USERNAME with your MySQL user and your password when prompted.

  • Then run the below DROP and CREATE commands:
mysql> DROP database DATABASE_NAME;
mysql> CREATE database DATABASE_NAME;

In this the, DATABASE_NAME is the name of your database.

In this way you can empty a MySQL database using phpMyAdmin and SSH in simple steps.

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
Claim the discount before it’s too late. Use the coupon code:
Note: Copy the coupon code and apply it on checkout.