---
title: "How to truncate MySQL tables in SiteWorx"
source: "https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/truncate-mariadb-mysql-tables/"
description: "Learn how Nexcess clients on physical (non-cloud) accounts can perform the truncate table operation for MySQL tables from SiteWorx."
vertical: "Sites & Stores"
date: "2019-09-10"
last_modified: "2026-07-02"
---

# How to truncate MySQL tables in SiteWorx

NoteThe truncate table operation functions as a quick way to remove all rows from a table while leaving the table itself intact. You cannot roll back this operation. Make sure you have a current backup

I

f you are a Nexcess client on a physical (non-cloud) server, you can perform the truncate table operation from SiteWorx. If you are a Nexcess Cloud client, see instead [How to truncate MySQL tables in Nexcess Cloud](https://docs.nexcess.com/sites-stores/control-panel/interworx/siteworx/database-management/truncate-mariadb-mysql-tables/).

1. Log in to your SiteWorx account. 
    - If you do not know your password, click **Forgot your password** on the login page.
2. On the left, select **Hosting Features > MySQL > PhpMyAdmin**.
3. Select the correct database from the list on the left.
4. Select the **check box** corresponding to the desired table from the Table List.
5. From the With selected list, click **Empty.**
6. Click **Yes** when prompted.