Server Management

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

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

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

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

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

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

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

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

An SQL dump that stops with Unknown collation: 'utf8mb4_0900_ai_ci' is not necessarily damaged. The destination may not recognize the comparison rule ...

You select an SQL backup, start the import, and receive a blank page or timeout several minutes later. Retrying immediately is tempting. However, the ...