How to Truncate MySQL Tables From the CLI

Notice anything different?

We've enhanced the appearance of our portal and we're working on updating screenshots. Things might look different, but the functionality remains the same.

September 11, 2019

By Jason Dobry

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

For 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.

View Fully Managed Hosting Plans

Let's Talk