Database Administration
Store and Query JSON Data in MySQL
Use the JSON column type to store documents MySQL actually understands. This tutorial inserts JSON, reads keys with JSON_EXTRACT and the ->> shorthand, edits…
//
Tag: Command Line
Database Administration
Write a Common Table Expression With WITH in MySQL
Name a query result with WITH so the rest of the statement reads it like a table. This tutorial rewrites a nested subquery as…
Database Administration
Rank Rows With ROW_NUMBER and RANK in MySQL
Number and rank rows in MySQL with the ROW_NUMBER, RANK and DENSE_RANK window functions. Learn how PARTITION BY restarts the count per group, how…
Server Administration
Analyze Apache Access Logs From the Terminal
Analyze Apache access logs from the terminal with awk, sort, uniq and grep: top client IPs, most-requested URLs, status-code counts and 404 hunts —…
Server Administration
Run Scheduled Jobs With systemd Timers
systemd timers run scheduled jobs with a .timer/.service pair: OnCalendar sets the schedule, systemctl list-timers shows it, journalctl keeps the logs, and Persistent=true catches…
Server Administration
Back Up a Server With tar and gzip
Back up a server with tar and gzip: one dated, compressed archive of the site's files, verified with -tzf, restore-tested with -xzf, and copied…