interconnectit/Search-Replace-DB
Search Replace DB
Search-Replace-DB is a MySQL search and replace tool designed for updating database strings and migrating PHP-based websites and content management systems. It functions as a database migration utility to update references and table engines when moving sites to new servers or domains.
The project specifically handles the updating of text inside serialized PHP arrays and objects, recalculating lengths to maintain data structure integrity and prevent corruption. It also includes a converter for modifying storage engines and character collations across multiple MySQL tables.
Additional capabilities include regular-expression pattern matching, dry-run simulations to preview pending modifications, and the ability to limit operations to specific tables or columns. The tool also supports encrypted database connections using SSL certificates.
Features
- PHP Serialized Data Processing - Parses and updates PHP serialized strings by recalculating lengths to prevent data corruption during text replacement.
- Regex Pattern Matching - Uses regular expression pattern matching to identify and replace complex text strings within database columns.
- CMS Reference Updates - Updates configuration strings and site URLs across PHP-based content management systems after a domain change.
- Serialized Data Integrity Preservation - Replaces text within database strings while maintaining the integrity of serialized PHP data structures.
- Serialized String Updaters - Updates text inside serialized arrays and objects without corrupting the data structure.
- MySQL Domain Migrations - Facilitates moving a website to a new server or domain by updating database references and table settings.
- Database Content Find-and-Replace Tools - Provides a script for finding and replacing strings within MySQL databases while preserving serialized PHP data integrity.
- Database Search and Replace Operations - Provides utilities to search for specific text or regular expressions and replace them directly within database content.
- Database Migration Tools - Updates database references and table engines when migrating PHP-based websites and content management systems.
- Serialized String Substitutions - Swaps text within a database while preserving the integrity of serialized data structures.
- Table and Column Whitelists - Allows limiting search and replace operations to specific tables or columns to reduce execution risk.
- Table Performance Optimizers - Improves performance and data sorting by changing storage engines and character collations across MySQL tables.
- Schema Modification - Executes SQL alter statements to modify table storage engines and character collations for database optimization.
- Database Modification Previews - Calculates and displays the total number of pending modifications before they are applied to the live database.
- MySQL Table Converters - Changes storage engines and character collations across multiple MySQL tables.
- Table Engine and Collation Converters - Updates the storage engine or character collation of database tables to optimize data storage and sorting.
- Operation Targeting - Limits search and replace operations to specific tables or columns to prevent accidental changes to unrelated data.
- Dry Run Simulations - Simulates replacement operations to calculate and preview pending modifications without committing changes to the database.
