Resource Topic: Database Management
Changing passwords for MariaDB users in the Nexcess Cloud
Nexcess Cloud web hosting plans provide a great way to manage your website databases and database MariaDB users from the Nexcess Client Portal. Learn…
Unblock site/block site with password protection for dev and staging environments
How do you restrict access to your development or staging website created for testing purposes? The answer is password protection — used as a…
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.
Convert MyISAM to InnoDB tables for database performance
With regard to database tables and storage engines, after learning why we would want to convert MyISAM to InnoDB for better performance, let’s review…
Accessing the website database in the Nexcess Client Portal
You can access your website database from the Site Dashboard within the Nexcess Client Portal by using the phpMyAdmin utility as an excellent tool…
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…
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…
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…
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.
How to download backup files with SiteWorx
Use SiteWorx to download backup files, even if originally created without SiteWorx.