1. Home
  2. Knowledge Base
  3. Hosting
  4. How to truncate database tables

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:

Was this article helpful?

Related Articles