PJR Sales and Service - Knowledgebase - How can I empty a MySQL database?

Computer Co-op, CornerNET Internet Gateway, and PJR Solutions is owned by PJR Sales & Service. Quality products and online services since 1991. We can be your
Complete Computer Connection

Hosting @ $5.95

Domains @ $16.98

Home Page

Knowledgebase
You are here: Portal Home > Knowledgebase > cPanel Related Issues > MySQL management issues > How can I empty a MySQL database?

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.

Add to Favourites
Print this Article

Also Read

How can I import a large database to my account? PhpMyAdmin times out. (Views: 11279)

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database (Views: 10054)

I get syntax error when trying to run a MySQL query. (Views: 1061)

I don't have enough privileges for creating/dropping databases in PhpMyAdmin (Views: 2706)

I have problems accessing my MySQL database remotely (Views: 5298)