Articles in this category
How to Delete a MySQL Database in cPanel
Whether getting rid of an unneeded database or a corrupted one, this tutorial walks through how to delete a MySQL database in cPanel.
How to monitor running MariaDB and MySQL queries
You need a way to check the status of your running MariaDB and MySQL queries, and so we will cover how to monitor them…
How to Repair MySQL Tables
Learn how to repair MySQL tables in this helpful article using either phpMyAdmin or the MySQL CLI. Learn about MySQL database repair and tab…
How to show running MySQL queries in SiteWorx
Use phpMyAdmin from your SiteWorx account to show running MySQL queries following the guidance in the article.
How to truncate MySQL tables in SiteWorx
Learn how Nexcess clients on physical (non-cloud) accounts can perform the truncate table operation for MySQL tables from SiteWorx.
Importing and exporting a MySQL database
Learn how to export and import MySQL databases for backups. This guide covers using the command line (`mysqldump`), phpMyAdmin, and WP-CLI.
Installing MySQL community edition on new AlmaLinux 8 servers
Install MySQL Community on new AlmaLinux 8. *NEW SERVERS ONLY* (data loss risk). Steps: prep, repo, install, secure.
Interworx: MariaDB and MySQL troubleshooting
Fix InterWorx "replyCode: 500" on MySQL DB/user creation. Issue: empty MySQL user. Guide: diagnose via iworx.log, then remove from `mysql.us…
MariaDB / MySQL Database Administration
Your hub for MySQL administration. Find tutorials on installation, user management, backups, optimization, and troubleshooting to master you…
MariaDB Databases & MariaDB Setup in the Nexcess Cloud
Learn how to create and manage MariaDB databases and users in the Nexcess Client Portal. This guide covers setup, password retrieval, and as…
Modifying Fields in Database Tables with PhpMyAdmin
Our tutorial walks you through examples of how to modify a field within your MySQL or MariaDB database. Learn to edit a field within…
Moving the MySQL Data Directory
Move MySQL `datadir`: Step-by-step guide using `rsync`, symlinks, & `my.cnf` updates. Includes CloudLinux notes & critical backup advice.