We use cookies to understand how you interact with our site, to personalize and streamline your experience, and to tailor advertising. By continuing to use our site, you accept our use of cookies and accept our Privacy Policy.
Contact Us
Contact Us
Sign in
Sign in
Nexcess Logo

Nexcess Knowledge Base

|
Tag : mysql-database
March 03, 2023

Truncating MariaDB/MySQL tables in the Nexcess Cloud

Truncating MariaDB/MySQL tables in the Nexcess Cloud
Truncating MariaDB/MySQL tables allows you to easily remove all data from the chosen MySQL database tables without having to manually delete and recreate them.
March 03, 2023

Importing and exporting a MySQL database

Importing and exporting a MySQL database
You can export/import MySQL databases using different tools. Exporting a MySQL database helps create a database backup for a website restoration process, cloning, or migration to a new server.
February 23, 2023

Top 6 free MariaDB and MySQL GUI tools in 2023

Top 6 free MariaDB and MySQL GUI tools in 2023
This post will introduce you to the top six free MariaDB and MySQL GUI tools available in 2023. Whether you're a novice or an expert, chances are you'll find the tool suitable for your needs.
February 21, 2023

Convert MyISAM to InnoDB tables for database performance

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 four methods for doing so.
January 31, 2023

How to access a WordPress database with connection errors

How to access a WordPress database with connection errors
In this article, we will learn how to access a WordPress database by troubleshooting and resolving the condition behind the "Error Establishing a Database Connection" message.
January 23, 2023

WordPress database setup — changing the database prefix

WordPress database setup — changing the database prefix
With regard to WordPress database setup and security, establishing a custom prefix for your database tables will harden your site against database-based hacker attacks.
November 02, 2022

How to monitor running MariaDB and MySQL queries

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 directly from your Nexcess Client Portal.
March 24, 2022

How to Create an SSH Tunnel for a MySQL Database

How to Create an SSH Tunnel for a MySQL Database
This article will guide you through creating an SSH tunnel for a MySQL database and managing your databases remotely
February 17, 2022

MySQL User Permissions for a Magento/Flex Cloud Plan

MySQL User Permissions for a Magento/Flex Cloud Plan
Easily manage MySQL user permissions for your Magento or Flexible Cloud Plan using the Nexcess Cloud SiteWorx Control Panel via the Nexcess Client Portal.
February 15, 2022

Tuning Your MySQL Database for Performance

Tuning Your MySQL Database for Performance
MySQL database tuning can make the difference regarding your website's overall speed, and therefore its first impression on visitors, so learn how to master it for database efficiency