How can I empty a MySQL database?

The easiest way to empty a MySQL database is through phpMyAdmin. 

Once in phpMyAdmin, select the database you wish to empty.

A list with all the database's tables will appear. Click [Check All] to select all tables.

Click the box [With selected:] and choose Drop and confirm. This will execute the DROP TABLE SQL query on all tables and the database will be emptied.

  • 48 A felhasználók hasznosnak találták ezt
Hasznosnak találta ezt a választ?

Kapcsolódó cikkek

Can I change the name of a MySQL database?

The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a...

How can I change my MySQL database collation?

Usually you will be interested in changing your MySQL collation in order to solve problems with...

How to change the database engine of a MySQL database table?

In this article we will show you how to change the database engine of a MySQL table. Let's...

How to change the MySQL timezone

When you develop your website, you may have to compare a certain date/time with the current...

How to change the password of a Mysql user in cPanel?

If you have already created a MySQL user through the cPanel -> Mysql Databases tool you may...