Articles in this category
MariaDB vs MySQL: Which database solution is right for you?
MariaDB vs. MySQL — choosing MariaDB over MySQL improves performance, adds more features, hardens security, and future-proofs your database…
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.
MSSQL Cloud Sites Databases
Manage MSSQL in Cloud Sites. Guides for backing up, restoring data, remapping users, and connecting via SQL Server Management Studio.
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 o…
MySQL Troubleshooting
MySQL troubleshooting guide: Resolve DB corruption, connection problems, full disks, remote access, & advanced errors.
MySQL User Permissions for a Magento/Flex Cloud Plan
For Magento/Flexible Cloud Plans, learn to manage MySQL user permissions in the Nexcess SiteWorx Control Panel. Grant, modify, and delete pr…
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…
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…
Nexcess Flex Plans Database Management
Manage databases on your Flex Plan using the InterWorx control panel. Create users, access phpMyAdmin, and perform essential database tasks.