interconnectit/Search-Replace-DB
Search Replace DB
Search-Replace-DB es una herramienta de búsqueda y reemplazo para MySQL diseñada para actualizar cadenas en bases de datos y migrar sitios web y sistemas de gestión de contenidos basados en PHP. Funciona como una utilidad de migración de bases de datos para actualizar referencias y motores de tablas al mover sitios a nuevos servidores o dominios.
El proyecto gestiona específicamente la actualización de texto dentro de arrays y objetos PHP serializados, recalculando las longitudes para mantener la integridad de la estructura de datos y evitar la corrupción. También incluye un conversor para modificar motores de almacenamiento y colaciones de caracteres en múltiples tablas MySQL.
Otras capacidades incluyen coincidencia de patrones mediante expresiones regulares, simulaciones de prueba (dry-run) para previsualizar modificaciones pendientes y la posibilidad de limitar las operaciones a tablas o columnas específicas. La herramienta también admite conexiones a bases de datos cifradas mediante certificados SSL.
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.
