This method requires SSH access. Nexcess clients on physical non-cloud servers must first enable SSH access and adjust their firewall settings in SiteWorx; Cloud accounts have SSH enabled by default.
Use the following procedure to perform the truncate table operation using the MySQL CLI:
mysql -u [username] -p [database_name)For example:
mysql -u johndoe -p data_mysite
truncate table [table_name]
For the complete MySQL documentation, refer to the MySQL website.
For 24-hour assistance any day of the year, contact our support team by email or through your Client Portal.
Our award-winning customer care team is here for you.
Contact Support