Database search and replace with serialization support
Better Search Replace handles database replacements while accounting for serialized data.
It supports serialized data across tables, lets users select specific tables, and offers a dry run that reports how many fields would be updated. Running a dry run first can help check the scope before applying a change.
Moving a site to a new URL or server
The documented migration sequence sets the new URL temporarily before replacing the old one in the database.
- Back up the database on the current site before making changes; incorrect search or replacement strings can damage it.
- Move the database to the new host.
- Set the new site URL in the new host’s
wp-config.php file.
- Run the replacement from the new admin URL, changing the old site URL to the new one.
- Remove the temporary URL setting from
wp-config.php. If needed, regenerate .htaccess by saving the Permalinks settings.
Multisite access and table scope
Multisite access depends on the user’s role and the dashboard they use.
- Subsite administrators can search and replace only within tables belonging to their subsite when working from that subsite’s dashboard.
- Network administrators and primary-site administrators can work across all network tables from the primary site’s dashboard. This distinction helps keep routine subsite changes within their intended scope.
- Access control can be changed in code with the
bsr_capability filter.
Pro tools for repeat searches and database changes
The paid version adds features for inspecting, repeating, and managing database work.
- Change details: view exactly what changed during a search and replace.
- Database backup and import: back up and import the database while running a search and replace.
- Saved profiles: save or load configurations for searches that need to be repeated.
- Priority email support: receive priority support from the developer.
- Support and updates: included for one year, making the paid option more relevant for ongoing or recurring work.
A widely adopted tool with support activity to watch
Broad adoption and many positive reviews give Better Search Replace a strong reputation, but its support record is worth considering for database-critical changes.
The plugin is among the directory’s most widely installed tools and has many positive reviews. It was updated roughly two months ago; its support forum shows three threads, none marked resolved. That is a limited sample, but it is a point to weigh alongside the documented risk of database damage: keep a separate backup and verify the dry-run results before applying replacements. The plugin suits site owners who need direct database URL changes, provided they are comfortable taking those precautions.
