We use cookies to understand how you interact with our site, to personalize and streamline your experience, and to tailor advertising. By continuing to use our site, you accept our use of cookies and accept our Privacy Policy.

Your Digital Commerce Experts
Nexcess Logo

How to truncate MySQL tables in SiteWorx

September 10, 2019

How Nexcess clients on physical (non-cloud) accounts can perform the truncate table operation from SiteWorx.

ATTENTION: The 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.

If 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.

  1. Log in to your SiteWorx account.
  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.


For 24-hour assistance any day of the year, contact our support team by email or through your Client Portal.

Jason Dobry