How to truncate MySQL tables in SiteWorx
Learn how Nexcess clients on physical (non-cloud) accounts can perform the truncate table operation for MySQL tables from SiteWorx.
Note
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. 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.
- Log in to your SiteWorx account.
- If you do not know your password, click Forgot your password on the login page.
- On the left, select Hosting Features > MySQL > PhpMyAdmin.
- Select the correct database from the list on the left.
- Select the check box corresponding to the desired table from the Table List.
- From the With selected list, click Empty.
- Click Yes when prompted.