Learn to Empty a MySQL Database in Simple Steps

You can empty the contents of a MySQL database using SSH or phpMyAdmin. However, before making any changes to your databases, make sure you backup your data using either phpMyAdmin or SSH.

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.