Nexcess Knowledge Base

Tag : data

March 03, 2023

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.

Posted in:

Tags:

repairing database tables,database tuning,data,mysql database management ,mysql servers and databases,mysql database,tuning your mysql database for performance ,database,database tables,mysql database,phpmyadmin,what are the best features of phpmyadmin?

March 03, 2023

By Kiki Sheldon

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.

Posted in:

Tags:

data,mysql database,wordpress database,mysql database management ,database using wp-cli,mysql servers and databases,database tables,database table names & sizes,database field names & details ,wp-cli commands for your wordpress database,data migration,how do you export a mysql database using phpmyadmin?

February 21, 2023

By Kiki Sheldon

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.

Posted in:

Tags:

wordpress database,data,mysql servers and databases,mysql database,database tables,database table names & sizes,web applications,woocommerce setup,store setup,mysql database,mysql database management

August 30, 2022

By Andrew Reynolds

WooCommerce: Export Orders from Your Online Store

Export WooCommerce orders to new sites. Learn to adjust export WooCommerce settings properly. And learn how to export WooCommerce orders from the database here.

Posted in:

Tags:

woocommerce sales,Ecommerce sales,data,database

September 11, 2019

By Jason Dobry