How to truncate database tables
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: