phpMyAdmin Video Tutorials - Screencast

Title: phpMyAdmin Video Tutorials Link: phpMyAdmin Video Tutorials Description: phpMyAdmin Video Tutorials include different tutorials covering: - How to Add Columns to a Database Table in phpMyAdmin. - How to Rename a Database Table in phpMyAdmin. - How to drop a database table in phpMyAdmin. - How to Drop Columns from a Database Table in phpMyAdmin. - How to drop a database in phpMyAdmin. - How to Rename a Database in phpMyAdmin. Continue reading

Update MariaDB from 10.0 to 10.3 on CentOS 7 - How-to

Title: Update MariaDB from 10.0 to 10.3 on CentOS 7 Link: Update MariaDB from 10.0 to 10.3 on CentOS 7 Description: The article assumes that the administrator is already presently working with MariaDB 10.0.X. It is considered best practice to consult the official documentation from MariaDB prior to updating/upgrading the current version. This is pertinent in doing because it is vital in understanding what exactly is going to be changed, updated, and even removed from one version to the next. Continue reading

How to Install PostgreSQL on Ubuntu 16.04 - How-to

Title: How to Install PostgreSQL on Ubuntu 16.04 Link: How to Install PostgreSQL on Ubuntu 16.04 Description: The PostgreSQL relational database system is a powerful, scalable, and standards-compliant open-source database platform. This guide will help you install and configure PostgreSQL on your Ubuntu 16.04 LTS (Xenial Xerus) Linode. Details: Language(s): English Resource Type: How-to Audience: Sysadmin, DevOps Software: Mysql, Linux, PostgreSQL, Ubuntu OS Version: Ubuntu 16.04 Category: Databases Learning Step or Phase: Install & Configure Published on: 2018 Need More Amazing FREE Learning Resources? Continue reading

How To Install the Latest MySQL on Debian 9 - How-to

Title: How To Install the Latest MySQL on Debian 9 Link: How To Install the Latest MySQL on Debian 9 Description: MySQL is a prominent open source database management system used to store and retrieve data for a wide variety of popular applications. MySQL is the M in the LAMP stack, a commonly used set of open source software that also includes Linux, the Apache web server, and the PHP programming language. Continue reading

How to Back Up Your PostgreSQL Database - How-to

Title: How to Back Up Your PostgreSQL Database Link: How to Back Up Your PostgreSQL Database Description: If you are using PostgreSQL in a production environment, it is important to take precautions to ensure that your users’ data is not lost. By frequently backing up your database, and/or automating backups with a cron task, you will be able to quickly restore your system in the event that your database is lost or corrupted. Continue reading

How To Import and Export Databases in MySQL or MariaDB - How-to

Title: How To Import and Export Databases in MySQL or MariaDB Link: How To Import and Export Databases in MySQL or MariaDB Description: Being able to import and export your database is an important skill to have. You can use data dumps for backup and restoration purposes, allowing you to recover older copies of your database in case of an emergency. You can also use them to migrate data to a new server or development environment. Continue reading

How to Optimize MySQL Performance Using MySQLTuner - How-to

Title: How to Optimize MySQL Performance Using MySQLTuner Link: How to Optimize MySQL Performance Using MySQLTuner Description: Database tuning is an expansive topic, and this guide covers only the basics of editing your MySQL configuration. Large MySQL databases can require a considerable amount of memory. For this reason, we recommend using a high memory Linode for such setups. Details: Language(s): English Resource Type: How-to Audience: Sysadmin, DevOps Software: Mysql, Linux, MySQLTuner Category: Databases Learning Step or Phase: Manage Published on: 2018 Need More Amazing FREE Learning Resources? Continue reading