Guides
Plain-English help for Linux, hosting and self-hosting.
Practical guides for people who run Linux, rent a host, or self-host their own services, plus the SQL Help MySQL tutorials rewritten for MySQL 8.
-
Linux and self-hosting
Securing a new server, file permissions, Docker Compose, Caddy, backups, and SSH from Windows.
-
SQL Help
The MySQL tutorials published on this domain in 2006 to 2009, rewritten for MySQL 8.
-
Web hosting, explained
Shared, VPS, cloud, dedicated and managed WordPress: how to choose, and a FAQ.
-
About WeFixTech
Who edits the site, how guides are made, and the history of the domain.
Latest guides
Linux and hosting
- Best Zigbee Coordinator for Home Assistant (UK)
- Best NVMe SSD for Raspberry Pi 5
- Best Docking Station for Linux: Docks That Just Work
- Best Printer for Linux: Picks That Just Work
- Best USB Bluetooth Adapter for Linux: Dongles That Just Work
- Best USB Wi-Fi Adapter for Linux: Plug and Play Picks (UK)
- Best Raspberry Pi 5 Kit for a Home Server (UK Picks)
- Best Mini PC for a Home Server in the UK
- Best VPS hosting UK for small sites and self-hosters
- Cheap web hosting UK: what you really pay after year one
- How to self-host a server for beginners
- Docker Compose basics for self-hosting
- Reverse proxy with automatic HTTPS using Caddy
- Server backups that restore: restic and 3-2-1
- Linux file permissions: chmod and chown
- Types of Web Hosting Explained, With a Plain-English FAQ
- First 10 minutes on a new Linux server
- How to choose a VPS without overpaying
- Shared hosting vs VPS: which do you need?
- PuTTY and SSH clients on Windows
- VLC media player: where to download it safely
SQL Help
- Best SQL books for beginners (2026)
- LEFT JOIN vs INNER JOIN: the difference
- SQL_CALC_FOUND_ROWS deprecated in MySQL 8
- MySQL stored procedures: a practical introduction
- MySQL transactions explained
- NULL vs empty string in MySQL
- MySQL AUTO_INCREMENT and LAST_INSERT_ID()
- Why are there gaps in my IDs?
- Convert VARCHAR dates to DATE in MySQL
- PHP and MySQL categories and sub-categories
- Get the latest row per group in MySQL
- Delete duplicate rows in MySQL
- Top N plus everything else in MySQL
- Comma-separated lists vs a junction table
- Create and fill a calendar table in MySQL
- MySQL booking availability queries
- INT(11) and MySQL integer types
- Save MySQL query output with column headers
- Transform data with MySQL LOAD DATA