Databases

MySQL troubleshooting guide: Resolve DB corruption, connection problems, full disks, remote access, & advanced errors.

MySQL Stored Procedures: Check for routines & ensure they’re in `mysqldump` backups using `–routines`. cPanel’s `/scripts/pkgacct` handles this.

Learn about the WordPress database structure, key tables like wp_options, wp_users, & wp_posts, and how wp-config.php connects your site.

MySQL command guide: Data dump/restore, password management, admin tasks (upgrades, root reset, slow log) & datadir/tmpdir setup.

MySQL batch table engine conversion: MyISAM <=> InnoDB. Get CLI scripts, rollback prep, & robust methods. *Always backup data first!*

InnoDB: MySQL/MariaDB’s default engine for performance & reliability. Guide: features, `SHOW ENGINES`, create/alter tables & fix issues.

This 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.

Use `mysqldump` to backup & restore MySQL/MariaDB. Learn to export DBs/tables, restore from SQL, & fix “trigger in wrong schema” errors.

MariaDB vs. MySQL — choosing MariaDB over MySQL improves performance, adds more features, hardens security, and future-proofs your database on a truly open source platform.

Our helpful guide shows you how to install phpMyAdmin on AlmaLinux to easily manage your MariaDB or MySQL databases. 

A database is an organized collection of information. It provides an efficient and organized mechanism for storing, managing, and retrieving data.

Easily add new database users in Plesk for specific access needs, like database administrators or third-party remote applications.