This tutorial provides a description of how to truncate database tables.Joomla 3.x. How to install engine and template on localhost
In order to truncate database tables, you should do the following:
Upload adminer.php script to the root directory on your server or access your database using hosting cpanel PhpMyAdmin tool.
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:
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:Joomla 3.x. How to install engine and template on localhost