How to Empty a MySQL database?

Step 1: Login to cPanel

Step 2: Once you’re logged in, locate the "Databases" section of cPanel. Within, there is an icon for "phpMyAdmin". Click on the “phpMyAdmin" icon.

Step 3. In “phpMyAdmin” screen select the database you would like to check and repair using the left menu.

Step 4. You will see a listing of your tables. Click "Check All" or use the check box to select specific tables and then from the drop down labelled “With Selected” choose "Empty Table". “Empty Table” option removes all information from the table/s, but leaves the table itself intact.

Step 5. This will execute the “EMPTY TABLE” SQL query to empty all information from the tables at once. On the next step, confirm you wish to proceed by clicking the Yes button.

Was this useful? Share it!

UK REGISTERED COMPANY 11074916 |
Copyright © 2019 - Solelyweb Ltd - All Rights Reserved |