How to truncate database tables

This tutorial provides a description of how to truncate database tables.

In order to truncate database tables, you should do the following:

1. Upload adminer.php script to the root directory on your server or access your database using hosting cpanel PhpMyAdmin tool.

2. Connect to your database by opening your website URL + /adminer.php in a browser (for example, www.my-website-url.com/adminer.php) and filling in your database credentials:

   

3. Select the tables that you need to truncate (we will select all the tables as an example) and click Truncate button:

   

Feel free to check the detailed video tutorial below: