Guides 11795 Published by Philipp Esselbach 0

The post explains why backing up a MySQL database is essential and shows how the command‑line tool mysqldump creates simple, portable SQL text files that can be copied to USB drives or cloud storage. It highlights that mysqldump offers a lightweight, transaction‑aware snapshot, making it suitable for production servers without locking tables and with low memory usage. The article walks through selecting target databases, adding stability options such as --single-transaction, --quick, disabling table locks, piping the output into gzip to save space, verifying the dump by restoring to a test database, and automating the process with cron jobs. Finally it cautions that for point‑in‑time recovery or zero downtime you might need binary logs or replication, but for most users mysqldump remains a solid, no‑extra‑software solution.

Guides 11795 Published by Philipp Esselbach 0

This guide walks you through getting the newest stable Redis on Debian 11 from the command line right up to a production ready state. It explains why the default apt package is often an older 2018 release, how it listens on all interfaces by default, and why that can break IPv4 clients during silent upgrades. After purging any existing Redis installation you add the official Redis APT repository, install the newer binary, optionally build from source for cutting edge features, then apply hardening tweaks such as binding only to localhost, requiring a strong password, disabling persistence, and setting a memory limit with an LRU eviction policy. Finally you restart the service, verify it listens only on 127.0.0.1, and run simple ping commands (with or without authentication) to confirm that the server is alive, secure, and running the expected version.

Guides 11795 Published by Philipp Esselbach 0

To install Docker CE on Rocky Linux 8 without the usual headaches, first ensure you have root or sudo privileges, disable the firewall temporarily, and remove any conflicting runtimes such as Podman. Next, add Docker’s official repository by installing the required package utilities and running the config‑manager command to point dnf at Docker’s CentOS repo, then install docker‑ce along with its CLI and containerd components. After that, enable and start the Docker service immediately, and test the installation by running a hello‑world container to confirm everything is wired up correctly. If you encounter errors such as permission denied or connection failures, check for SELinux enforcement, add your user to the docker group, or restart the service to resolve common pitfalls.

Guides 11795 Published by Philipp Esselbach 0

The guide shows a handful of command‑line tricks for pulling CPU details on Linux without opening any graphical interface. It starts with grepping /proc/cpuinfo for model name, MHz and cache size, then moves to the tidy lscpu output that lists cores, threads and architecture in plain text. For a quick count of usable processors it recommends nproc --all, while more advanced users can install Intel’s linux‑tools package and run lstopo to visualize NUMA nodes, cache hierarchies and core placement. The author also warns that tools like top or htop can mislead when looking for static hardware data, so choosing the right command for the job helps avoid chasing phantom bugs.