Tag : database

Blog

Running SQL Queries on 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

Listing and Switching Databases in PostgreSQL

Viking Coin
Intro to PostgreSQL Install and Connect to PostgreSQL 10 on Ubuntu 16.04 Creating and Deleting a PostgreSQL Database on Ubuntu 16.04 Listing and Switching Databases in PostgreSQL PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems. Its object-relational meaning that you’ll be able to use......
Blog

View the Selected MySQL Database on Linux via Command Line

Viking Coin
Pre-Flight Check These instructions are intended for viewing the selected MySQL database via the command line. I’ll be working from a sxi.io Web Core Managed CentOS 7 server, and I’ll be logged in as root. Login to MySQL First we’ll login to the MySQL server from the command line with......
Blog

Database 101: What Is a Database?

Viking Coin
Computers have been built to enhance the way we store, retrieve, and process information since their original invention. While initially designed to perform mathematical calculations, their power and capabilities grew along with the desire to more efficiently process different types of data. In order to harness this burgeoning capability for......
Blog

Install and Connect to PostgreSQL 10 on Ubuntu 16.04

Viking Coin
Intro to PostgreSQL Install and Connect to PostgreSQL 10 on Ubuntu 16.04 Creating and Deleting a PostgreSQL Database on Ubuntu 16.04 Listing and Switching Databases in PostgreSQL PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems. Its object-relational meaning that you’ll be able to use......
Blog

How To: Create a MySQL Database and User in cPanel

Viking Coin
Installation instructions for Content Management Systems (CMS) often require you to create a MySQL database for the application. But just how is that done on a cPanel server? In cPanel, scroll down to the MySQL section and click “MySQL Databases”: The first section, “Create New Database”, is where we will......
Blog

SQL Database Migration with SSMS

Viking Coin
Migrating MSSQL between servers can be challenging without the proper guidelines to keep you on track. In this article, I will be outlining the various ways to migrate Microsoft SQL Server databases between servers or instances. Whether you need to move a single database,  many databases, logins or stored procedures......
Blog

Creating and Deleting a PostgreSQL Database on Ubuntu 16.04

Viking Coin
Intro to PostgreSQL Install and Connect to PostgreSQL 10 on Ubuntu 16.04 Creating and Deleting a PostgreSQL Database on Ubuntu 16.04 Listing and Switching Databases in PostgreSQL PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems. Its object-relational meaning that you’ll be able to use......
Blog

Troubleshooting Microsoft SQL Server Error 18456, Login failed for user

Viking Coin
Login errors with Microsoft SQL Server (MSSQL) are a fairly common issue and can be easily solved with some basic troubleshooting steps. Before we dig in, let’s take a look at the details of the error to try and determine the cause. Solutions to Microsoft SQL Server Error 18456 Sometimes,......
Blog

Troubleshooting: Too Many Redirects

Viking Coin
The error “too many redirects” means that the website keeps being redirected between different addresses in a way that will never complete. Often this is the result of competing redirects, one trying to force HTTPS (SSL) and another redirecting back to HTTP (non-SSL), or between www and non-www forms of......
Blog

Common Postgres Tasks on CentOS 7

Viking Coin
This guide walks you through some common tasks surrounding a Postgres server. In this tutorial, we’ll cover installing Postgres, creating new databases and users, backing up databases, and more! Let’s dig in! Note: The remainder of this tutorial requires you to have root privileges. Start by either logging in as......
Blog

Installing Redis on Ubuntu 16.04/18.04

Viking Coin
What is Redis?  Redis or “REmote DIctionary Server” is defined as an open source, “key-value” database storage medium, which is additionally known as a data structure server. At its heart, Redis works with key-value pairs and stores data in a location that’s easily referenceable by two specific values. These key-value......