34 guides, scripts and tools for MariaDB / MySQL. Search them or pick a type. Press / to search.
Nothing matches. Try a shorter word or another section.
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
