Databases

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.

Nexcess Cloud web hosting plans provide a great way to manage your website databases and database MariaDB users from the Nexcess Client Portal. Learn more in this informative article.

Let’s examine the history of MySQL vs. MariaDB and see how they compare — MySQL vs. MariaDB — and the performance advantages behind why the Nexcess application stack is built using MariaDB.

Exporting a MySQL database helps create a database backup for a website restoration process, cloning, or migration to a new server. You can export/import MySQL databases using different tools.

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.

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.

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.

You can access your website database from the Site Dashboard within the Nexcess Client Portal by using the phpMyAdmin utility as an excellent tool for database management.

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.

Need a MariaDB tuner? Get a MariaDB tuning script in this article. Optimize your MariaDB performance tuning by following the expert tips from Nexcess.