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.

  • 29 Kasutajad peavad seda kasulikuks
Kas see vastus oli kasulik?

Seotud artiklid

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