To empty a database follow these steps:
- Go to cPanel >> Databases section >> phpMyAdmin menu. ...
- Select the database you wish to empty. ...
- Tick Check All to select all tables and choose the Drop option from the With selected drop-down list:
- This will execute the DROP TABLE SQL query to empty all the tables at once.
https://www.namecheap.com/support/knowledgebase/article.aspx/9945/2180/how-to-empty-a-mysql-database
×