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.

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

Kapcsolódó cikkek

What type of databases do you support? PGSQL and MySQL?

All our servers support MySQL and PostgreSQL databases. Also with any of our hosting packages...

How to repair a MySQL database?

In this article we will show you two ways to repair a MySQL database.  1) Through...

How to optimize a MySQL database using phpMyAdmin?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

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...

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database

In order to solve this issue follow these steps: Open the MySQL dump with a text editor on...