MariaDB / MySQL Database Administration
Your database is the beating heart of your website or application, holding everything from crucial customer data to your core content. Because databases are so vital, managing them, especially when running upgrades, dropping tables, or troubleshooting errors, can feel like high-stakes surgery. Fortunately, you don’t have to navigate these critical tasks blindly.
Whether you are provisioning a brand-new server, writing your first mysqldump command, or fine-tuning InnoDB variables to handle massive traffic spikes, this collection of guides provides the technical foundation you need. We cover both user-friendly graphical interfaces like cPanel and powerful command-line (SSH) techniques to help you securely and efficiently manage your MySQL and MariaDB environments.
Explore the guides below to learn how to:
- Manage Users and Access: Secure your data by safely creating and deleting specific database users, resetting root passwords, and connecting external development tools like VSCode SQLTools.
- Backup and Restore: Protect your server against catastrophic data loss by mastering manual backups,
mysqldumpexports, and full database restorations. - Maintain and Upgrade: Keep your environment secure and stable by safely upgrading database versions across various operating systems (Ubuntu, CentOS), checking for errors, and repairing corrupted tables.
- Tune for Performance: Speed up sluggish query times by understanding key MySQL variables, mastering database indexing, and batch-converting legacy storage engines.
MariaDB / MySQL Database Articles
This collection contains articles and resources for MariaDB / MySQL administration. The topics covered include initial setup, user management, replication, and performance tuning.
MySQL Troubleshooting
Read more: MySQL TroubleshootingMySQL troubleshooting guide: Resolve DB corruption, connection problems, full disks, remote access, & advanced errors.
Mysqldump
Read more: MysqldumpUse `mysqldump` to backup & restore MySQL/MariaDB. Learn to export DBs/tables, restore from SQL, & fix “trigger in wrong schema” errors.
Mysqldump stored procedures
Read more: Mysqldump stored proceduresMySQL Stored Procedures: Check for routines & ensure they’re in `mysqldump` backups using `–routines`. cPanel’s `/scripts/pkgacct` handles this.
Resetting Your MySQL Root Password
Read more: Resetting Your MySQL Root PasswordReset MySQL root password if security compromised. Change passwords every 90 days for enhanced server security.
Restoring a MySQL Database from a Backup
Read more: Restoring a MySQL Database from a BackupMade a change and something went wrong? Restoring a MySQL database from a backup is the fastest way to get your site back online. Here’s how.
Selecting a MySQL Database via Command Line and cPanel
Read more: Selecting a MySQL Database via Command Line and cPanelHave multiple MySQL databases? To avoid editing the wrong one, you must select it first. Here’s how to do it using cPanel or the command line.
Show (List) MySQL Databases via Command Line on Linux
Read more: Show (List) MySQL Databases via Command Line on LinuxFind out how to easily show (list) all MySQL databases on Linux via command line with our comprehensive tutorial.
Understanding key MySQL variables
Read more: Understanding key MySQL variablesThis guide explains key MySQL variables, their purpose, impact, and default values. It’s a reference for understanding server behavior and optimization, with caution for changes.