Blog

Guides from the NOC

Written from running the hardware — what breaks, why, and the command that fixes it.

7 posts matching “mariadb” · Clear

All 7 Most read VPS 5 cPanel 2
cPanel Upgrading MySQL/MariaDB in WHM Without Breaking cPanel Sites

Upgrading MySQL or MariaDB from WHM? Here's how to use the built-in upgrade tool safely, without corrupting cPanel databases, phpMyAdmin, or client sites.

10 August 2026 · 6 min · 15 views VPS MySQL/MariaDB Tuning on a VPS: my.cnf Settings That Matter

Slow WordPress or app on your VPS even with low CPU? Tune innodb_buffer_pool_size, max_connections, and tmp_table_size in my.cnf the right way.

28 July 2026 · 6 min · 9 views VPS Upgrading MySQL or MariaDB on a VPS Without Breaking Your Site

Upgrading MySQL or MariaDB on your VPS? Follow this backup-test-upgrade checklist so WordPress, WooCommerce, or your app doesn't break after the update.

28 July 2026 · 5 min · 13 views VPS MySQL Point-in-Time Recovery on a VPS Using Binary Logs

Restore MySQL to the exact second before a bad query hit with binary log point-in-time recovery. Setup, restore steps, and mistakes to avoid.

22 August 2026 · 7 min · 9 views cPanel MySQL "Unknown Collation" Error After Migration: Causes & Fix

Getting 'Unknown collation utf8mb4_0900_ai_ci' when importing a MySQL 8 database dump into cPanel's older MariaDB? Here's the exact cause and fix, step by step.

21 August 2026 · 5 min · 19 views VPS Install a LAMP Stack on a Fresh Ubuntu VPS: Full Guide

Step-by-step guide to installing Apache, MySQL/MariaDB, PHP and a free SSL cert on a bare Ubuntu VPS, plus the vhost and .htaccess errors people hit.

20 July 2026 · 6 min · 8 views VPS Install a LEMP Stack on a Fresh Ubuntu VPS: Full Guide

Step-by-step guide to installing Nginx, PHP-FPM, MySQL/MariaDB and a free SSL cert on a bare Ubuntu VPS, plus the errors people hit along the way.

20 July 2026 · 6 min · 14 views