Articles in this category
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 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.user`.
MariaDB / MySQL Database Administration
Your hub for MySQL administration. Find tutorials on installation, user management, backups, optimization, and troubleshooting to master your database.
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 assigning user…
Moving the MySQL Data Directory
Move MySQL `datadir`: Step-by-step guide using `rsync`, symlinks, & `my.cnf` updates. Includes CloudLinux notes & critical backup advice.
MySQL Commands
MySQL command guide: Data dump/restore, password management, admin tasks (upgrades, root reset, slow log) & datadir/tmpdir setup.
MySQL Performance: Converting MySQL to MariaDB
Converting MySQL to MariaDB is beneficial for optimizing your website and database. In our tutorial, we cover how to upgrade your database on your…
MySQL Troubleshooting
MySQL troubleshooting guide: Resolve DB corruption, connection problems, full disks, remote access, & advanced errors.