Shared on Mage Dispatch · 05 May 2025
Mohamed Tawfik published a full Magento 2 Database Documentation portal to make life easier when dealing with complex table structures and relationships.
Standalone PHP script to perform complete encryption key rotation: inventories encrypted values across all tables (including JSON/serialized and nested), re-encrypts them to the latest key, verifies, and safely retires old keys. Includes scan/explain/re-encrypt/verify/retire-keys and code-scan commands with dry-run, dump, and rollback support plus a step-by-step runbook.
Scans varchar product attributes used in flat tables and sets column lengths based on actual data instead of 255, preventing MySQL 1118 indexing failures.
Downloads and sanitizes remote databases over SSH, then imports and configures them locally to mirror production or staging in minutes. Built on Magerun2 and can optionally handle WordPress.
Mage Dispatch is a community-run archive and bi-weekly newsletter for the Magento, Adobe Commerce and Mage-OS ecosystem. Modules, articles, security advisories and tools, hand-picked by developers and shared so good work does not disappear into the void.
Browse the latest links → Explore by topic → Submit a link → About us →
