4 articles tagged 'sql'

• 
  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 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.

• ← Previous
• Next →