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: Fix Them Safely

Legacy MySQL dumps can fail on zero dates. Learn how to inspect sql_mode, audit affected columns, use a session-only import bridge, and plan the 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

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.

AI Images Need a Chain of Custody, Not Just a Disclosure Label

2026-08-04

AI image labels are only the endpoint. Learn how to test C2PA credentials through editing, CMS, CDN and agency handoffs while preserving evidence.

MCP Just Went Stateless: Audit the Integrations Behind Your AI Tools

2026-08-03

The 28 July 2026 MCP release removes protocol sessions and changes discovery, tasks, caching, OAuth and tracing. A practical guide to auditing the move.

SEO Trends for 2026: What Actually Changed Since 2024

2026-08-03

A practical guide to what changed in SEO between 2024 and 2026, from AI and multimodal search to Core Web Vitals, privacy and local visibility.

INP and Green SEO Share a Backlog: Cut the Work Every Visit Repeats

2026-08-03

INP and sustainable web work often expose the same waste. Use field data, profiling, caching and performance budgets to build one practical backlog.

AI crawler policy now has verbs: separate search, RAG, and training

2026-08-02

AI crawler rules now need separate decisions for search, RAG, and training, backed by practical testing across robots.txt, CDNs, WAFs, and CMS controls.

WordPress Supports Old PHP; Your Production Server Shouldn’t

2026-08-01

WordPress still runs on legacy PHP, but compatibility is not a security policy. Build and test your upgrade path before PHP 8.2 support ends.

The AI-built tool your team relies on needs an owner

2026-07-31

AI-built internal tools can become business-critical before anyone owns them. Here is how to secure, review, monitor, and retire them without blocking useful work.

Your AI model has an expiry date: build the migration lane now

2026-07-30

AI models retire on a schedule. Learn how to map dependencies, test replacements, release safely and preserve a working rollback route.