Tag : data management

Blog

Deleting Tables from a Database with phpMyAdmin

Viking Coin
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......
Blog

Inserting Fields into Database Tables with phpMyAdmin

Viking Coin
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......
Blog

Renaming Database Tables with phpMyAdmin

Viking Coin
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......
Blog

Exporting Databases and Tables with phpMyAdmin

Viking Coin
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......
Blog

MySQL Performance: How To Leverage MySQL Database Indexing

Viking Coin
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......
Blog

How To Install MySQL / MariaDB on Fedora 20

Viking Coin
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),......
Blog

MySQL Performance: Identifying Long Queries

Viking Coin
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......
Blog

How To Install MySQL / MariaDB on Fedora 21

Viking Coin
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),......
Blog

HIPAA Compliant Hosting Checklist

Viking Coin
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......
Blog

How To Install MySQL / MariaDB on Fedora 22

Viking Coin
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),......
Blog

Searching Through a Database with phpMyAdmin

Viking Coin
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......
Blog

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

Viking Coin
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),......
Blog

SQL Databases Migration with Command Line

Viking Coin
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......
Blog

MySQL Performance: MyISAM vs InnoDB

Viking Coin
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......