Emergency server help: get in touch

MariaDB / MySQL

MariaDB and MySQL guides and scripts: upgrades, InnoDB tuning, slow queries, backups, point-in-time recovery and end-of-life planning.

34 guides, scripts and tools for MariaDB / MySQL. Search them or pick a type. Press / to search.

34 pages

MariaDB latest version: current 12.3 LTS and 13.0 releases, support timeline and upgrade paths

Live MariaDB release numbers (refreshed twice a day), the difference between LTS and rolling releases, which version a hosting server should run after 10.6 went end of life, and how to check and upgrade on cPanel, WHM and DirectAdmin.

October 30, 2026

MariaDB Watchdog Script: Restart MariaDB or MySQL Only When It Is Really Hung

A Bash watchdog for MariaDB and MySQL: checks that the server answers SELECT 1 within a time limit, saves diagnostics, and restarts only when you allow it and only when it is safe: not during startup or crash recovery, not during a backup, at most twice an hour. Report-only by default.

October 18, 2026

SQL Cheat Sheet: MySQL, MariaDB and PostgreSQL Syntax

Everyday SQL syntax with the MySQL, MariaDB and PostgreSQL differences that trip people up, plus admin queries for database servers.

October 9, 2026

Plesk “Unable to connect to database”: PleskDBException Fix

Fix Plesk "Unable to connect to database" and PleskDBException errors: start MariaDB, free disk space, repair .psa.shadow, plesk repair db and InnoDB crashes.

October 7, 2026

InnoDB Page Corruption: Recover a Crashed MariaDB on cPanel

Fix InnoDB page corruption on a cPanel MariaDB server: read the error, copy the data directory, use innodb_force_recovery safely, dump and rebuild, or restore from backup.

October 7, 2026

Asterisk CDR Reports from MySQL/MariaDB (FreePBX asteriskcdrdb)

Query FreePBX call detail records in asteriskcdrdb with SQL: calls per day, per extension, missed calls, top destinations, busiest hour, CSV export and indexes.

October 7, 2026

Restore a File, Database or Account from a DirectAdmin Backup (CLI, Tested)

Restore one file, one database or a whole account from a DirectAdmin .tar.zst backup on the command line. Tested on DirectAdmin 1.712 with real screenshots.

October 6, 2026

Find cPanel, DirectAdmin and MySQL Passwords from the CLI (and One-Time Login Links)

Short answer: cPanel and DirectAdmin do not keep the root, WHM or admin password anywhere you can read it back. They are normal Linux user passwords, stored only as hashes in /etc/shadow. You either reset them or, better, log in with a one-time login link created from the command line. What you can read as

October 6, 2026

MySQL/MariaDB won’t start: crash recovery runbook Pro

When MariaDB won't start after a crash, this runbook reads the error log first, matches the common causes, walks innodb_force_recovery levels 1 to 6 safely, and rebuilds from a dump on cPanel and DirectAdmin.

September 30, 2026

Disk full on a production server: recovery runbook Pro

A recovery runbook for a disk full on a production server: safe space to free first, inode exhaustion, what never to delete, and how to bring MySQL, Exim and Dovecot back cleanly after ENOSPC.

September 30, 2026

cPanel Migration Preflight Check Pro

A cPanel migration preflight check that compares the source server with the destination over SSH and prints a go/no-go report: versions, PHP, collisions, IPs, DNS, disk and database risks.

September 30, 2026

Restic Backup Script for Offsite Backups

A restic backup script for cron: dumps every MariaDB/MySQL database, backs up to any restic repository, applies daily/weekly/monthly retention, checks integrity and test-restores a random file.

September 30, 2026

Free website test

Is your website set up right?

Check SSL, security headers, redirects, robots.txt, sitemap, llms.txt and security.txt in one test. It takes about 30 seconds.