Nexcess Logo

Nexcess Knowledge Base

Knowledge Base Home
|
Tag : wordpress-database
June 01, 2023

How to truncate MySQL tables from the CLI

How to truncate MySQL tables
Learn how to truncate MySQL tables from the CLI using this article from Nexcess. Truncation of MySQL tables is simple with these eight simple steps.
March 03, 2023

Importing and exporting a MySQL database

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

Top 6 free MariaDB and MySQL GUI tools in 2024

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

Moving a WordPress site to a new server

Moving a WordPress site to a new server
You know your website the best, so knowing how to perform a WordPress migration manually can save you time and money by moving a WordPress site to a new server yourself.
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.
February 16, 2022

Optimize WordPress Database with WP-CLI Commands

WP-CLI Commands for Your WordPress Database
Optimize your WordPress database with WP-CLI and improve website performance. Learn how to create a searchable database in WordPress today.
January 25, 2022

WordPress Database Size: Find WP DB Size with WP-CLI

Find your database size quickly using the WordPress Command Line Interface (WP-CLI)! The WP database size is at your fingertips, and here's how to find it!
Find your database size quickly using the WordPress Command Line Interface (WP-CLI)! The WP database size is at your fingertips, and here's how to find it!
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.