Categories
How To

Deleting Tables from a Database with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

Inserting Fields into Database Tables with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

How To Check a MySQL Database for Errors in cPanel

cPanel Tutorial: MySQL I. How To Set up a Database using the MySQL Database Wizard in cPanel II. How To Create a MySQL Database in cPanel III. How To Delete a MySQL Database in cPanel IV. How To Create a MySQL Database User in cPanel V. How To Assign a User to a MySQL Database […]

Categories
How To

Renaming Database Tables with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

How To Create a MySQL Database User in cPanel

cPanel Tutorial: MySQL I. How To Set up a Database using the MySQL Database Wizard in cPanel II. How To Create a MySQL Database in cPanel III. How To Delete a MySQL Database in cPanel IV. How To Create a MySQL Database User in cPanel V. How To Assign a User to a MySQL Database […]

Categories
How To

Exporting Databases and Tables with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

How To Delete a MySQL Database in cPanel

cPanel Tutorial: MySQL I. How To Set up a Database using the MySQL Database Wizard in cPanel II. How To Create a MySQL Database in cPanel III. How To Delete a MySQL Database in cPanel IV. How To Create a MySQL Database User in cPanel V. How To Assign a User to a MySQL Database […]

Categories
How To

How To Change a MySQL Database User’s Password in cPanel

cPanel Tutorial: MySQL I. How To Set up a Database using the MySQL Database Wizard in cPanel II. How To Create a MySQL Database in cPanel III. How To Delete a MySQL Database in cPanel IV. How To Create a MySQL Database User in cPanel V. How To Assign a User to a MySQL Database […]

Categories
How To

How To Delete a MySQL Database User in cPanel

cPanel Tutorial: MySQL I. How To Set up a Database using the MySQL Database Wizard in cPanel II. How To Create a MySQL Database in cPanel III. How To Delete a MySQL Database in cPanel IV. How To Create a MySQL Database User in cPanel V. How To Assign a User to a MySQL Database […]

Categories
How To

MySQL Performance: How To Leverage MySQL Database Indexing

MySQL Performance MySQL Performance: Identifying Long Queries MySQL Performance: MyISAM vs InnoDB MySQL Performance: How To Leverage MySQL Database Indexing MySQL Performance: MySQL vs. MariaDB MySQL Performance: Converting MySQL to MariaDB MySQL Performance: System Configuration File & Routine Maintenance MySQL Performance: InnoDB Buffers & Directives MySQL Performance: MyISAM Throughout this tutorial, we will cover some […]

Categories
How To

How To Install MySQL / MariaDB on Fedora 20

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), […]

Categories
How To

MySQL Performance: Identifying Long Queries

MySQL Performance MySQL Performance: Identifying Long Queries MySQL Performance: MyISAM vs InnoDB MySQL Performance: How To Leverage MySQL Database Indexing MySQL Performance: MySQL vs. MariaDB MySQL Performance: Converting MySQL to MariaDB MySQL Performance: System Configuration File & Routine Maintenance MySQL Performance: InnoDB Buffers & Directives MySQL Performance: MyISAM Every MySQL backed application can benefit from […]

Categories
How To

How To Install MySQL / MariaDB on Fedora 21

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), […]

Categories
How To

HIPAA Compliant Hosting Checklist

In this guide, we outline the essential requirements for HIPAA compliant servers and how sxi.io Web helps fulfill these necessities.   What is HIPAA Compliance? HIPAA, or the Health Insurance Portability and Accountability Act of 1996, was passed by Congress to protect sensitive user information related to health insurance. This act helps to reduce health […]

Categories
How To

How To Install MySQL / MariaDB on Fedora 22

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), […]

Categories
How To

Searching Through a Database with phpMyAdmin

Tutorial: phpMyAdmin I. Becoming Familiar with Databases in phpMyAdmin II. Running SQL Queries on a Database with phpMyAdmin III. Searching Through a Database with phpMyAdmin IV. Creating Tables in a Database with phpMyAdmin V. Deleting Tables from a Database with phpMyAdmin VI. Importing Databases and Tables with phpMyAdmin VII. Exporting Databases and Tables with phpMyAdmin […]

Categories
How To

How to Install the Open Query Graph engine (OQGRAPH) for MariaDB 10.0 on CentOS 6

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), […]

Categories
How To

SQL Databases Migration with Command Line

What if you have dozens of SQL databases and manually backing up/restoring each database is too time-consuming for your project? No problem! We can script out a method that will export and import all databases at once without needing manual intervention. For help with transferring SQL Logins and Stored Procedures & Views take a look […]

Categories
How To

How To Remove a User from a MySQL Database in cPanel

cPanel Tutorial: MySQL I. How To Set up a Database using the MySQL Database Wizard in cPanel II. How To Create a MySQL Database in cPanel III. How To Delete a MySQL Database in cPanel IV. How To Create a MySQL Database User in cPanel V. How To Assign a User to a MySQL Database […]

Categories
How To

MySQL Performance: MyISAM vs InnoDB

MySQL Performance MySQL Performance: Identifying Long Queries MySQL Performance: MyISAM vs InnoDB MySQL Performance: How To Leverage MySQL Database Indexing MySQL Performance: MySQL vs. MariaDB MySQL Performance: Converting MySQL to MariaDB MySQL Performance: System Configuration File & Routine Maintenance MySQL Performance: InnoDB Buffers & Directives MySQL Performance: MyISAM   A major factor in database performance […]