Databases

Made a change and something went wrong? Restoring a MySQL database from a backup is the fastest way to get your site back online. Here’s how.

Have multiple MySQL databases? To avoid editing the wrong one, you must select it first. Here’s how to do it using cPanel or the command line.

You can create MySQL users to help you organize your database management, giving each user access to specific databases and specific privileges. You can assign MySQL users to databases and give them permissions using: cPanel or the command line.

Limit user access and secure your Cloud Sites data. Learn how to easily assign read-only permissions for your MSSQL and MariaDB database users.

Upload databases that are 50MB or less into Cloud Sites using phpMyAdmin or myLittleAdmin database managers.

Nexcess Cloud web hosting plans provide a great way to manage your website databases and database MariaDB users from the Nexcess Client Portal. Learn more in this informative article.

Learn how to export and import MySQL databases for backups. This guide covers using the command line (`mysqldump`), phpMyAdmin, and WP-CLI.

How do you restrict access to your development or staging website created for testing purposes? The answer is password protection — used as a way to block a site or unblock a site for visitors.

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 four methods for doing so.

You can access your website database from the Site Dashboard within the Nexcess Client Portal by using the phpMyAdmin utility as an excellent tool for database management.

You need a way to check the status of your running MariaDB and MySQL queries, and so we will cover how to monitor them directly from your Nexcess Client Portal.

Gain knowledge on how to clean up websites infected with malware. Plus, learn how the Nexcess migration team helps as you switch hosting providers — if even your website has existing malware issues.