Databases

MySQL is a versatile RDBMS that can be used for anything from simple product databases to complex WordPress website. Exporting a database puts it in a dump file that can later be imported to another system. This guide will walk you through how to export the database and import it from a dump file in MySQL.

MariaDB is an open source, fully compatible, relational database management system. It is commonly used as a replacement for MySQL due to its fault tolerance, speed, and scalability. In this tutorial, learn how to install MariaDB on Ubuntu.

This article explores multiple ways to connect to a PostgreSQL database from Linux and Windows.

When you install MySQL on your system, the root user may not be able to access it. Using the ALTER command, you can modify the root user and allow it access to MySQL.

Learn how the Pliops XDP-powered BMC instance helps scale and improve database performance. See the database and HPC boosts gained from the Pliops card and how to deploy these BMC servers.

Data types are important to understand as a name and a data type define each column in a database table. Learn all about MySQL data types and when to use them in this comprehensive guide.

A MySQL database has been lost, and you’re scrambling to restore a copy from your last backup. This guide shows different methods for backing up and restoring a MySQL database.

MySQL databases are frequently employed in website building, data-driven app management, and data analysis. This article shows you how to connect to a MySQL database on Windows, macOS, and Linux.

In cloud computing, master-slave data replication refers to storing the same information on multiple servers. One server controls the group, and the other devices handle the work within the same node. This guide will walk you through how to set up master-slave replication in MySQL

Database schemas are a central concept in database design and modeling. Learn more about what a database schema is and how it works in this comprehensive article.