CraftRoq Relocate DB

Overview

Move a site from staging to production, switch to HTTPS, change a domain, or rename something everywhere it appears, without breaking anything.

Preview first, always

Every replacement starts as a dry run that changes nothing and shows exactly what would change, per table and column, with before/after examples. Only a completed dry run can be applied, and applying it repeats exactly what was previewed.

Serialized data and JSON handled properly

Serialized values are rewritten token by token with every length recalculated, without unserializing them, so no plugin code runs. URLs inside JSON, as page builders store them, are found and replaced too. Values that could be corrupted are left alone and reported.

Made for large databases

Tables are processed in small batches, so there are no timeouts or memory limits to hit. Progress is saved after every batch, and a job can continue from where it stopped.

Also included

• Each batch is one database transaction, saved completely or not at all
• A downloadable file of the original values of everything a replacement changed
• Up to five search/replace pairs in one pass
• Table and column selection, case-insensitive and whole-word matching
• Live progress, a searchable job history and a log
• Database export and import (.sql / .sql.gz), with the site address changed on the way
• WP-CLI: wp crq search-replace and wp crq resume

Requirements

• WordPress 6.5 or newer
• PHP 8.1 or newer