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:
- Log in to your hosting account using SSH:
mysql -u [username] -p [database_name)
For example:mysql -u johndoe -p data_mysite
- Enter your password.
- Execute:
truncate table [table_name]
Other resources
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.