![Nexcess Logo](/static/92f52f39870524ccb6985d4ceddc5e08/41821/logo-nx-white.png)
Nexcess Knowledge Base
June 01, 2023
By Nexcess
How to truncate MySQL tables from the CLI
![How to truncate MySQL tables](https://cdn.sanity.io/images/v6oximkk/production/7e3f7aef31ef585013de161904c39aa6dd5f6e6c-1024x504.png?w=1024&h=504&auto=format)
Learn how to truncate MySQL tables from the CLI using this article from Nexcess. Truncation of MySQL tables is simple with these eight simple steps.
Posted in:
Tags:
mysql database,mysql query optimization,database,data,mysql database management ,database tables,database tuning,wordpress database,database table names & sizes,database field names & details ,mysql servers and databases,tuning your mysql database for performance ,woocommerce setup,Magento,web applications,website design,website performance
March 03, 2023
By Kiki Sheldon
Truncating MariaDB/MySQL tables in the Nexcess Cloud
![Truncating MariaDB/MySQL tables in the Nexcess Cloud](https://cdn.sanity.io/images/v6oximkk/production/01a47749baccf71ea79f45c27f770a786a8c8513-1600x900.png?w=1600&h=900&auto=format)
Truncating MariaDB/MySQL tables allows you to easily remove all data from the chosen MySQL database tables without having to manually delete and recreate them.
Posted in:
February 23, 2023
Top 6 free MariaDB and MySQL GUI tools in 2024
![Top 6 free MariaDB and MySQL GUI tools in 2024](https://cdn.sanity.io/images/v6oximkk/production/c782534ad1033b8bbd76c3a7bc70b79ee1faba43-1600x900.png?w=1600&h=900&auto=format)
This post will introduce you to the top six free MariaDB and MySQL GUI tools available in 2024. Whether you're a novice or an expert, chances are you'll find the tool suitable for your needs.
Posted in:
January 31, 2023
By Kiki Sheldon
How to access a WordPress database with connection errors
![How to access a WordPress database with connection errors](https://cdn.sanity.io/images/v6oximkk/production/c09e45cdb3e12bb9ad7f2c693dbfbeade791b112-1600x900.png?w=1600&h=900&auto=format)
In this article, we will learn how to access a WordPress database by troubleshooting and resolving the condition behind the "Error Establishing a Database Connection" message.
January 23, 2023
By Christy Joy
WordPress database setup — changing the database prefix
![WordPress database setup — changing the database prefix](https://cdn.sanity.io/images/v6oximkk/production/b377edd91fa78d911c53d0318b8f72fbdec793f1-1600x900.png?w=1600&h=900&auto=format)
With regard to WordPress database setup and security, establishing a custom prefix for your database tables will harden your site against database-based hacker attacks.
February 15, 2022
Tuning Your MySQL Database for Performance
![Tuning Your MySQL Database for Performance](https://cdn.sanity.io/images/v6oximkk/production/45daa08797c0f61a034dade9827015dd55faac39-1600x900.png?w=1600&h=900&auto=format)
Avoid a slow MySQL database and avoid a slow website! Delight your visitors with the performance! Reduce your server costs with MySQL database efficiency!
Grow your online business faster with news, tips, strategies, and inspiration.
- .htaccess
- Affiliates
- Applications
- Backups
- Billing
- Business
- CDN
- CDN SSL
- Client Portal
- Content Delivery Networks (CDNs)
- Control Panel Tools
- Craft CMS
- Cron Jobs
- Databases
- Dev Sites
- Domain Management
- Drupal
- Ecommerce
- Enterprise Hosting
- ExpressionEngine
- FTP
- File Management
- Getting Started
- Hosting
- IP Management
- Magento
- Magento 1
- Magento 2
- Membership sites
- Miscellaneous
- Nexcess
- Nexcess Email Services
- NodeWorx
- Other Applications
- Other Best Practices
- PCI DSS
- PWA
- Performance
- Reports and Monitoring
- SSH
- SSL
- Scripts
- Security
- SiteWorx
- StoreBuilder
- Third Party Clients
- WPQuickStart
- Web design
- Web development
- Website Management
- Websites
- WooCommerce
- WordPress