A practical toolkit for the day-to-day administration of MySQL and MariaDB: backups, replication, user/grant audits, slow-query analysis, InnoDB health, and tuning references. Everything is real, runn
Browse the actual product documentation and code examples included in this toolkit.
Key features of MySQL Admin Scripts
• **MySQL 8.0** or **MariaDB 10.3+** (most queries also work on MySQL 5.7; • The standard **`mysql`** and **`mysqldump`** clients. • For `scripts/xtrabackup_full.sh`: **Percona XtraBackup** (8.0 for MySQL 8.0, • `performance_schema` enabled (default in 8.0) for `sql/02`, `03`, `06`. • **Credentials are never stored in this kit.** Every script reads them from a • **`mysql_backup.sh`** — `mysqldump --single-transaction` (consistent, no write
**MySQL 8.0** or **MariaDB 10.3+** (most queries also work on MySQL 5.7;
The standard **`mysql`** and **`mysqldump`** clients.
For `scripts/xtrabackup_full.sh`: **Percona XtraBackup** (8.0 for MySQL 8.0,
`performance_schema` enabled (default in 8.0) for `sql/02`, `03`, `06`.
**Credentials are never stored in this kit.** Every script reads them from a
**`mysql_backup.sh`** — `mysqldump --single-transaction` (consistent, no write
Configure MySQL Admin Scripts parameters to see how the product works.
# 0) Make the scripts executable after unzipping. chmod +x scripts/*.sh # 1) Load the demo schema into a scratch database. mysql -u root -p -e "CREATE DATABASE IF NOT EXISTS adminkit_demo;" mysql -u root -p adminkit_demo < examples/sample_schema.sql # 2) Audit accounts for over-privilege (read-onl