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.

Your Digital Commerce Experts
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]

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.

Jason Dobry