Join my community / free newsletter — sign up here

mysql

By Greg Nowak, 6 August, 2021

Mysqldump Encoding: How to Prevent Broken Characters in Database Exports

Prevent broken text in MySQL exports by checking column metadata, choosing the right dump charset, and proving the restore before migration handoff.

MySQL Zero-Date Import Errors: A Safer Fix for Legacy Data

Fix MySQL zero-date import errors without weakening the whole server. Audit the data, use a session-only bridge, and plan a durable cleanup.

Install a Specific MySQL Version on Ubuntu Without Creating Upgrade Debt

Choose a supported MySQL release on Ubuntu, install it through Oracle’s APT repository, and handle exact-version pinning without creating hidden upgrade debt.

Tags

mysql

Review Greg on Google

Cloudflare Changed DoH JSON. What Else Is Parsing DNS as Text?

2026-08-12

Cloudflare’s DoH JSON change exposes brittle DNS parsing. Find affected scripts, test both formats, and choose a safer integration contract.

Your Website Can Answer Questions Now. Should It?

2026-08-11

NLWeb makes conversational website search practical to deploy. The real question is whether your content, users and team are ready to support it.

AI Search Finally Has Reports. Now Connect Visibility to Revenue

2026-08-11

Google and Bing now expose first-party AI search data. The real task is connecting citations and impressions to analytics, CRM outcomes, and revenue.

The Bot Passed Your CAPTCHA. What Did It Do Next?

2026-08-11

Passing a challenge is only one signal. Session analysis, server-side validation and endpoint-specific controls help reduce bot abuse without blocking customers.

WordPress 7.1 Moves Image Work Into the Browser—Test Every Media Hook

2026-08-11

WordPress 7.1 shifts image processing into supported browsers. Here is what to test across hooks, CDNs, formats, security headers, and fallbacks.

Prompt Caches Have Write Costs Now—Audit What Your Workflow Reuses

2026-08-10

GPT-5.6 makes cache writes billable. See how to spot wasted writes, stabilise prompt prefixes, place breakpoints and measure whether caching pays.

The AI Crawler in Your Logs May Be Wearing a Borrowed Name

2026-08-09

A User-Agent is a claim, not proof. See how to verify AI crawler traffic before it shapes reporting, robots.txt decisions, or WAF exceptions.

AI Agents Need a Spending Brake, Not Just a Billing Dashboard

2026-08-08

AI agent costs can climb inside a single workflow. Runtime budgets, loop detection, outcome metrics, and safe handoffs keep that spending under control.

Drupal 12 Slipped to December. Drupal 10 Still Runs Out of Road

2026-08-07

Drupal 12 arrives as Drupal 10 support ends in December 2026. Moving to Drupal 11.3+ first keeps two mandatory upgrades manageable.

EU OpenAI Residency Is a Migration Project, Not a Dashboard Toggle

2026-08-05

An EU-resident OpenAI API setup needs a new project, regional routing, dependency and state migration, compatibility testing, and clear governance evidence.