November 17, 2026 - 04:29

Server Management

General Problems Windows Server Troubleshooting: Where to Start When Things Fail

“The server is down” can mean several different things: a website returns an error, Remote Desktop cannot connect, a file share is slow, or the operat...

Server Management Set Up Let’s Encrypt HTTPS on Ubuntu with Certbot

Let's Encrypt issues TLS certificates, and Certbot handles requesting, installing and renewing them. This guide uses Certbot's snap installation with ...

Server Management Install PostgreSQL on Ubuntu: Roles, Connections and Backups

This setup takes PostgreSQL from an Ubuntu package installation to a database that an application can connect to. It also includes a restore test, so ...

Server Management Install MySQL on Ubuntu: Users, Backups and Connection Checks

A working MySQL installation needs more than a running service. Your application needs its own account, a database to use and a backup you can restore...

Server Management Install Tomcat 10.1 on Ubuntu 24.04 LTS with APT

Using distribution packages for Tomcat 10.1 on Ubuntu 24.04 LTS keeps service, account and update management together. This guide targets a new, separ...

Server Management Install Nginx and Apache on Ubuntu Without Port Conflicts

Nginx and Apache can each serve a website on their own. They can also work together, but they cannot both own the same listening address and port. Ins...

Server Management Build a Bash Menu for Creating and Deleting Test Files

A menu script is a useful way to practice input, branching and loops in Bash. It is also an easy place to make a destructive mistake if a filename is ...

Databases How to Verify a MySQL Backup After Restoring It

A successful import message does not establish that the backup contains everything the application needs. The wrong database may have been selected, s...

Databases MySQL Duplicate Entry 1062: Conflicts During SQL Import

During an SQL import, ERROR 1062: Duplicate entry means a PRIMARY or UNIQUE key would be violated. It does not necessarily mean the same row appears t...

Databases PHP and MySQL Character Encoding Problems: Diagnosing utf8mb4

If a name such as “Çağrı” appears as garbled symbols, do not immediately run ALTER TABLE across the database. The value may have been stored incorrect...