We use cookies to understand how you interact with our site, to personalize and streamline your experience, and to tailor advertising. By continuing to use our site, you accept our use of cookies and accept our Privacy Policy.
Contact Us
Contact Us
Sign in
Sign in
Nexcess Logo

How to Truncate MySQL Tables From the CLI

September 11, 2019

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:

1. Log in to your hosting account using SSH:

mysql -u [username] -p [database_name)

For example:

mysql -u johndoe -p data_mysite

2. Enter your password.

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.

Jason Dobry