bytefyre

ByteFyre DB Replace is a robust, developer-friendly tool for performing search and replace operations across your WordPress database. It is designed to handle complex data structures, including serialized arrays and JSON objects, ensuring your data remains uncorrupted during migrations or domain changes.
Key Features:
<ul>
<li>Safe Serialization Handling: Automatically detects, unserializes, replaces, and re-serializes data to prevent breakage.</li>
<li>JSON Support: Safely handles JSON encoded strings within your database.</li>
<li>Dry Run / Preview: Test your replacements before applying them. See exactly what will change with a “Diff” view.</li>
<li>Deep Linking: Preview results include direct links to the affected Posts or Pages (for viewable content).</li>
<li>Backup Integration: Automatically creates a SQL backup of affected tables before running a live replacement.</li>
<li>Undo Capability: Rollback changes instantly if something goes wrong.</li>
<li>Primary Key Batching: Uses efficient ID-based batching to handle massive tables without timeout.</li>
<li>CSV Export: Export your preview results for offline analysis.</li>
</ul>

ByteFyre DB Replace

Professional database search and replace tool with safety features, serialization support, and live previews.

Kerfred

This plugin fixes the serialized strings in the wp_options table. It recalculate the length of each strings. 
It can be useful after a migration if you have done a global search/replace in the SQL dump.
Major features include:
<ul>
<li>Repair the options table</li>
<li>Repair the postmeta table</li>
<li>Restore the lost text widgets</li>
</ul>
<h3>Translations</h3>
<ul>
<li>English (default)</li>
<li>French (fr_FR)</li>
<li>other can be translated</li>
</ul>

FG Fix Serialized Strings

Fix the broken serialized strings in the options and postmeta tables

ByteFyre DB Replace vs FG Fix Serialized Strings