How to empty a MySQL database using phpMyAdmin?
1. Go to cPanel >Databases section > phpMyAdmin menu:
2. Select the database you wish to empty. On the left you will see a list with all the database tables (you may have just one database if only one website is hosted):
3. Choose to Check All to >select all tables > choose the Drop option from the with a selected drop-down list:
4. The Drop Table SQL will empty all the tables at once. By clicking the Yes button confirm your wish:
Useful Links