Nexcess Knowledge Base

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.

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.

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.

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.

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.

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.

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.

If you are on a Magento Plan or Flexible Cloud Plan, you can connect to the MySQL server remotely by allowing an IP address via the IP whitelisting process using the Cloud SiteWorx Control Panel