Articles in this category
Manual Cloud Sites MariaDB Database Backup
Create a manual backup of your MariaDB database from the Cloud Sites control panel.
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…
MariaDB performance tuning tips at Nexcess
Optimize MariaDB performance with our tuning script and expert tips. Learn to use MySQLTuner and benchmarking to get a faster database today.
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 on a truly open source…
Migrations — how Nexcess handles websites infected with malware
Gain knowledge on how to clean up websites infected with malware. Plus, learn how the Nexcess migration team helps as you switch hosting providers…
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…
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.
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.