
Nexcess Knowledge Base
March 03, 2023
By Kiki Sheldon
Truncating MariaDB/MySQL tables in the Nexcess Cloud

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:
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 31, 2023
By Kiki Sheldon
How to access a WordPress database with connection errors

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

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.
November 02, 2022
How to monitor running MariaDB and MySQL queries

You need a way to check the status of your running MariaDB and MySQL queries, and so we will cover how to monitor them directly from your Nexcess Client Portal.
March 24, 2022
By Rajil Rajan
How to Create an SSH Tunnel for a MySQL Database

This article will guide you through creating an SSH tunnel for a MySQL database and managing your databases remotely
February 17, 2022
MySQL User Permissions for a Magento/Flex Cloud Plan

Easily manage MySQL user permissions for your Magento or Flexible Cloud Plan using the Nexcess Cloud SiteWorx Control Panel via the Nexcess Client Portal.
February 15, 2022
Tuning Your MySQL Database for Performance

MySQL database tuning can make the difference regarding your website's overall speed, and therefore its first impression on visitors, so learn how to master it for database efficiency
Grow your online business faster with news, tips, strategies, and inspiration.
- .htaccess
- Affiliates
- Applications
- Backups
- Billing
- CDN
- CDN SSL
- Client Portal
- Content Delivery Networks (CDNs)
- Control Panel Tools
- 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
- 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