5 articles tagged 'database'

Jan 3, 2025

How to Connect to a Remote MySQL/MariaDB Server via SSH Tunnel

Let's see how you can use an SSH Tunnel to securely connect to a remote MySQL/MariaDB database server. You can also use it to take backups from the remote server with mysqldump.

Jan 2, 2025 , updated on: Jan 3, 2025

How to use MySQL Binary Logging to Update Site Incrementally?

Let me show you how to update a site incrementally by making use of MySQL/MariaDB binary logs. Learn how to use the mysqlbinlog/mariadb-binlog utility effectively to replicate changes to a remote database from a local staging area.

Dec 11, 2024

What is a Database, by the way?

Ever wondered what a database actually is? What's the difference between database and database management system? SQL vs. NoSQL? This article tries to demystify those questions.

Dec 10, 2024

How to master SQL? What all things to learn?

SQL - Structured Query Language is the language to interact with relational databases including MySQL, MariaDB, PostreSQL, and MS SQL. Here is a list of the topics you may need to learn in order to master it, from beginner level to advanced.

May 19, 2024

How to Install MariaDB Server in Ubuntu 24.04 LTS

MariaDB is an alternative to MySQL, let's see how to setup a MariaDB server on a Linux machine running Ubuntu 24.04 LTS.