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 Truncate Tables from the CLI Step #1
1. Log in to your hosting account using SSH:
mysql -u [username] -p [database_name)
MySQL Truncate Tables from the CLI Step #1 - Example
mysql -u johndoe -p data_mysite
MySQL Truncate Tables from the CLI Step #2
2. Enter your password.
MySQL Truncate Tables from the CLI Step #3
3. Execute: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.
Not a Nexcess Customer Yet?
Get faster speeds on Nexcess servers and fully managed hosting plans. Stronger security, scalability, and 24/7/365 award-winning hosting support are just a few of the reasons why people choose Nexcess.
Check out our plans or contact us to get started today.