Nexcess Logo

Nexcess Knowledge Base

Knowledge Base Home
|
Tag : database
June 01, 2023

How to truncate MySQL tables from the CLI

How to truncate MySQL tables
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.
May 25, 2023

Changing passwords for MariaDB users in the Nexcess Cloud

Changing passwords for MariaDB users in the Nexcess Cloud
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.
April 27, 2023

MySQL vs. MariaDB: Nexcess application stack with MariaDB

MySQL vs. MariaDB: Nexcess application stack with MariaDB
Let's examine the history of MySQL and MariaDB and see how they compare — MySQL vs. MariaDB — and the performance advantages behind why the Nexcess application stack is built using MariaDB.
April 25, 2023

Managed WordPress & WooCommerce: How to make a WordPress site live

Managed WordPress & WooCommerce: How to make a WordPress site live
Once your site is good to go after design and testing phases are done, you can take your WordPress site live by following the steps provided in this article for how to make a WordPress site live.
March 03, 2023

Truncating MariaDB/MySQL tables in the Nexcess Cloud

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.
February 23, 2023

Top 6 free MariaDB and MySQL GUI tools in 2024

Top 6 free MariaDB and MySQL GUI tools in 2024
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.
January 31, 2023

How to access a WordPress database with connection errors

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

WordPress database setup — changing the database prefix

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

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.
October 25, 2022

MariaDB performance tuning tips at Nexcess

MariaDB performance tuning tips at Nexcess
Need a MariaDB tuner? Get a MariaDB tuning script in this article. Optimize your MariaDB performance tuning by following the expert tips from Nexcess.
We use cookies to understand how you interact with our site, to personalize and streamline your experience, and to tailor advertising. By continuing to use our site, you accept our use of cookies and accept our Privacy Policy.