Articles in this category
Understanding the WordPress database structure
Learn about the WordPress database structure, key tables like wp_options, wp_users, & wp_posts, and how wp-config.php connects your site.
Upgrading MySQL
Planning a MySQL upgrade? Review supported upgrade paths, understand MariaDB migrations, and find step-by-step guides for WHM, Ubuntu, CentOS, and Plesk.
Upgrading MySQL on CentOS
Safely upgrade MySQL on an unmanaged CentOS server. Learn how to handle backups, fix old password hashes, update binaries, and import tables via SSH.
Upgrading MySQL on Ubuntu
This tutorial is for the purpose of upgrading MySQL on an unmanaged server with an Ubuntu operating system. If you have CentOS or are…
Upgrading MySQL/MariaDB on core managed servers
Safely upgrade MySQL/MariaDB: Step-by-step guide for Core Managed servers. Includes pre-checks, backups (`rsync`, `mysqldump`), upgrade & follow-up.
Using MySQL commands with Plesk on Linux
Learn to use MySQL commands as root on a Plesk Linux server, understand /etc/psa/.psa.shadow, and set up passwordless MySQL access via /root/.my.cnf.
Using rsync for backups on Linux/Unix systems
Learn what `rsync` is and how to use it for fast, reliable backups on Linux. Our guide covers incremental file transfers for local and…
What Does Purge the CDN Mean? Purging the Nexcess CDN
Updated your website but not seeing changes? Learn what purging a CDN cache means and how to clear the Nexcess CDN to deliver your…
What is MySQL Indexing?
What is MySQL indexing? Learn how it speeds up database queries by replacing slow linear searches with efficient binary sorting to improve server performance.