Repair & Optimize all Mysql Databases one liner
Repair and optimize all MySQL databases at once with mysqlcheck — a one-liner that runs on every table without logging into MySQL.
All the articles with the tag "scripting".
Repair and optimize all MySQL databases at once with mysqlcheck — a one-liner that runs on every table without logging into MySQL.
Set, verify, and sync your timezone in Ubuntu using timedatectl — one command to fix the clock on a newly provisioned server.
socat wires TCP, UDP, Unix sockets, files, and serial ports together. Port forwarding, OpenSSL tunnels, traffic capture — this is netcat with superpowers.
Write bash scripts that don't silently fail — set -euo pipefail, error handling, input validation, and logging patterns for production scripts.
echo is convenient but inconsistent across systems; printf is portable and precise — know when to use each and avoid the gotchas.
Master bash for loops, while loops, and seq for sequential counting — iterate over files, ranges, and arrays without losing your mind.
Count files in a directory (recursively or not) with find, ls, and tree — quick one-liners for when du just isn't telling you enough.
Extract tar.gz, tar.bz2, tar.xz — flags demystified, compression compared, directory extraction, and the gotchas that trip you up.
logrotate keeps your /var/log from eating the disk — configure rotation schedules, compression, and retention for any service log.
Master MySQL from the command line: connect, query databases, manage users, repair tables, optimize—everything you keep Googling, one reference.
Remove spaces and special characters from filenames using bash loops, rename, find, and parameter expansion tricks.
sed is the stream editor for making text substitutions, deletions, and insertions in files — the patterns you'll use 90% of the time.