Contact
Site: US UK AU |

How to truncate MySQL tables in SiteWorx

How to truncate MySQL tables in 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 Classic (non-Cloud) client, 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 the Client Portal.

Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
 
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How to perform one-time backups with SiteWorx
Added on Wed, Dec 19, 2018
How to view your bandwidth usage
Added on Wed, May 23, 2018
How to restart your server
Added on Mon, Dec 17, 2018
How to purchase a wildcard SSL certificate
Added on Mon, Dec 17, 2018
How to create a subdomain with SiteWorx
Added on Wed, Dec 19, 2018
How to show running MySQL queries from the CLI
Added on Mon, Dec 17, 2018
How to add secondary domains with SiteWorx
Added on Fri, Jun 1, 2018
How to change permissions for MySQL users
Added on Thu, Dec 20, 2018
How to add client accounts as a reseller
Added on Mon, Oct 22, 2018
How to generate a CSR
Added on Thu, Jun 7, 2018