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 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 the Client Portal.

Article Rating (2 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 rekey your SSL certificate
Added on Wed, Aug 15, 2018
How to download backup files with SiteWorx
Added on Tue, Dec 18, 2018
How to schedule automatic backups with SiteWorx
Added on Thu, Dec 20, 2018
How to truncate MySQL tables from the CLI
Added on Mon, Dec 17, 2018
How to perform one-time backups with SiteWorx
Added on Wed, Dec 19, 2018
How to repair MySQL tables
Added on Fri, Sep 14, 2018
How to generate a CSR
Added on Tue, Dec 30, 2014
How to change PHP versions in SiteWorx
Added on Mon, Aug 13, 2018
How to create a subdomain with SiteWorx
Added on Wed, Dec 19, 2018
How to generate CSRs
Added on Thu, Jun 7, 2018