CraftRoq Relocate DB changes text across your database: moving a site from staging to production, switching to HTTPS, changing a domain, or renaming something everywhere it appears.<\/p>\n\n
It is built for doing that on real sites without breaking them.<\/p>\n\n
Every replacement starts as a dry run. It searches the tables you choose, changes nothing, and shows exactly what would change: rows and replacements per table and column, values it would leave alone and why, and before\/after examples. Only a completed dry run can be applied, and applying it repeats exactly what was previewed.<\/p>\n\n
Plugins and themes store settings as serialized PHP. A plain text replacement breaks those values whenever the length changes. Relocate rewrites serialized data token by token and recalculates every length, without unserializing it, so no plugin code runs and objects, private properties, references and numbers stay exactly as they were. URLs inside JSON (as page builders store them, with escaped slashes) are found and replaced too.<\/p>\n\n
A value is left untouched, and reported, when changing it could corrupt it: serialized data that is already broken, a custom serialized format only its own class understands, or JSON that would become invalid.<\/p>\n\n
Tables are processed in small batches by primary key, a few seconds per request, so there are no timeouts or memory limits to hit however big the tables are. Progress is saved after every batch. If the page is closed or the connection drops, the job can be continued from the last completed batch.<\/p>\n\n
wp crq search-replace<\/code> and wp crq resume<\/code>.<\/li>\n<\/ul>\n\n\n\n- Upload the plugin to
\/wp-content\/plugins\/craftroq-relocate-db<\/code>, or install it from the Plugins screen.<\/li>\n- Activate it.<\/li>\n
- Open Relocate DB<\/strong> in the admin menu.<\/li>\n<\/ol>\n\n\n
\nDo I still need a backup?<\/h3><\/dt>\nYes. Take a full database backup before replacing anything. The file of original values covers what a replacement changed, but it is not a substitute for a backup.<\/p><\/dd>\n
Can I undo a replacement?<\/h3><\/dt>\nThere is no undo button. Each replacement can save the original value of everything it changed to a downloadable .sql.gz<\/code> file, and importing that file (for example with phpMyAdmin, or gunzip -c file.sql.gz | mysql your_database<\/code>) puts those values back. It overwrites any edits made to those values since, so use it soon after the replacement.<\/p><\/dd>\nDoes it change serialized data safely?<\/h3><\/dt>\nYes. Serialized values are rewritten with their lengths recalculated, and checked to still be readable afterwards. Values that could not be changed safely are left as they were and listed in the results.<\/p><\/dd>\n
What happens if I close the page during a replacement?<\/h3><\/dt>\nThe batch in progress either completes or is rolled back (on InnoDB tables, which WordPress uses by default). Open the job from the Dashboard or History and continue it: it picks up from the last completed batch.<\/p><\/dd>\n
What happens if an import fails or I close the page?<\/h3><\/dt>\nNothing in the tables your site uses has changed. The tables in the file are built under temporary names and only put in place, all together, once the whole file has run. A failed import can be resumed or discarded, and one whose page was closed is offered again on the Import screen. The database needs room for both copies until the import finishes.<\/p><\/dd>\n
Does it support Multisite?<\/h3><\/dt>\nNo. Multisite is not supported. On a Multisite network the plugin does not run, and says so on the Plugins screen.<\/p><\/dd>\n
Which tables does it search?<\/h3><\/dt>\nThe tables you tick. By default those are the tables with your WordPress prefix. Other tables in the same database can be added, and each table's text columns can be switched off one by one. The plugin's own tables are never searched.<\/p><\/dd>\n
How do I use it from WP-CLI?<\/h3><\/dt>\nwp crq search-replace https:\/\/staging.example.com https:\/\/example.com --dry-run shows what would change. Without --dry-run<\/code> the command asks for confirmation and applies the dry run it just made. See wp help crq search-replace<\/code> for all options.<\/p><\/dd>\nDoes it send any data anywhere?<\/h3><\/dt>\nNo. Everything happens in your own database. Nothing is sent to CraftRoq or anyone else.<\/p><\/dd>\n\n<\/dl>\n\n\n
1.1.0<\/h4>\n\n\n- Removed unused styles and code. No change to how the plugin works.<\/li>\n<\/ul>\n\n
1.0.0<\/h4>\n\n\n- First release: search and replace with dry runs, serialized data and JSON support, database import and export, history, and WP-CLI commands.<\/li>\n<\/ul>","raw_excerpt":"Safely search and replace URLs and text across your WordPress database, with dry runs, serialized data support and a full history.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sq.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/381355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sq.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/sq.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/sq.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=381355"}],"author":[{"embeddable":true,"href":"https:\/\/sq.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/craftroq"}],"wp:attachment":[{"href":"https:\/\/sq.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=381355"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/sq.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=381355"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/sq.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=381355"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/sq.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=381355"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/sq.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=381355"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/sq.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=381355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}