Nexcess Knowledge Base
June 01, 2023
By Nexcess
How to truncate MySQL tables from the CLI
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
Importing and exporting a MySQL database
You can export/import MySQL databases using different tools. Exporting a MySQL database helps create a database backup for a website restoration process, cloning, or migration to a new server.
Posted in:
Tags:
data,mysql database,wordpress database,mysql database management ,database using wp-cli,mysql servers and databases,database tables,database table names & sizes,database field names & details ,wp-cli commands for your wordpress database,data migration,how do you export a mysql database using phpmyadmin?
February 23, 2023
Top 6 free MariaDB and MySQL GUI tools in 2023
This post will introduce you to the top six free MariaDB and MySQL GUI tools available in 2023. Whether you're a novice or an expert, chances are you'll find the tool suitable for your needs.
Posted in:
February 21, 2023
By Kiki Sheldon
Convert MyISAM to InnoDB tables for database performance
With regard to database tables and storage engines, after learning why we would want to convert MyISAM to InnoDB for better performance, let’s review four methods for doing so.
January 23, 2023
By Christy Joy
WordPress database setup — changing the database prefix
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 16, 2022
WP-CLI: Create, Update, Optimize Your WordPress Database
Create, update, and optimize your WordPress database using the WordPress Command Line Interface (WP-CLI) tool. Keep WordPress database well-maintained!
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