Articles in this category
Mysqldump
Use `mysqldump` to backup & restore MySQL/MariaDB. Learn to export DBs/tables, restore from SQL, & fix "trigger in wrong schema" errors.
Mysqldump stored procedures
MySQL Stored Procedures: Check for routines & ensure they're in `mysqldump` backups using `–routines`. cPanel's `/scripts/pkgacct` handles this.
New Relic monitoring of WordPress and database performance
Application Performance Monitoring (APM), the New Relic monitoring product, integrates with our Nexcess platform to help online store owners find performance bottlenecks.
Nexcess: MySQL & IP Whitelisting for Remote Access
It’s possible to allow MySQL remote connections from any host. Learn how to whitelist MySQL host IP. Grant MySQL remote access with this article.
phpMyAdmin Web-Based Database Management
Master phpMyAdmin with our guides. Learn to import/export data, manage users, run queries, and optimize your database with this powerful web interface.
Remote MySQL Connections in cPanel
Liquid Web explains how you can connect to MySQL remotely in cPanel step-by-step. Learn more!
Resetting Your MySQL Root Password
Reset MySQL root password if security compromised. Change passwords every 90 days for enhanced server security.
Restoring a MySQL Database from a Backup
Made a change and something went wrong? Restoring a MySQL database from a backup is the fastest way to get your site back online.…
Selecting a MySQL Database via Command Line and cPanel
Have multiple MySQL databases? To avoid editing the wrong one, you must select it first. Here's how to do it using cPanel or the…
Setup phpMyAdmin on Linux (AlmaLinux)
Our helpful guide shows you how to install phpMyAdmin on AlmaLinux to easily manage your MariaDB or MySQL databases.
Understanding key MySQL variables
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…
Understanding the InnoDB storage engine in MySQL
InnoDB: MySQL/MariaDB's default engine for performance & reliability. Guide: features, `SHOW ENGINES`, create/alter tables & fix issues.