Knowledgebase

How to truncate MySQL database tables with phpMyAdmin

First, you have to go to the Databases section of the Pixie control panel. There you'll see a phpMyAdmin link on the right side in the black area. Click on it to access phpMyAdmin. Once you do it you'll see all the databases listed in the left frame. Click on the database that has in it the table(s) that you want to truncate. This will display all the tables of the particular database in the right frame. Find the table(s) that you need and mark the checkbox in front of it. Then scroll down the page and from the With selected drop-down menu choose Empty. After that click on the Go button that's in the lower right corner. You'll be asked whether you really want to truncate the table(s); just click on Yes to confirm.

You can also truncate database tables through SSH. If you want to know how to do it, read the article on truncating MySQL database tables via SSH.

Was this answer helpful?

 Print this Article

Also Read