Better Search Replace

Descripción

Al mover tu sitio WordPress a un nuevo dominio o servidor es posible que quieras realizar una búsqueda/sustitución en la base de datos de todo lo que no funcione correctamente. Afortunadamente hay varios plugins disponibles para esta tarea, sin embargo cada uno de ellos tiene un modo diferente de hacerlo y de qué características ofrecer. Este plugin unifica las mejores características de estos plugins, incorporando las siguientes funcionalidades en un solo plugin:

  • Compatible con la serialización en todas las tablas
  • Posibilidad de elegir tablas específicas
  • La posibilidad de ejecutar un «simulacro» para ver cuántos campos se actualizarán
  • Ningún requisito del servidor más allá de estar ejecutando una instalación de WordPress
  • Compatible con WordPress multisitio

Características para ahorrar tiempo disponibles en la versión Pro:

  • Ve exactamente que ha cambiado durante una búsqueda/sustitución
  • Copias de seguridad e importación de la base de datos al ejecutar una búsqueda/sustitución
  • Priority email support from the developer of the plugin
  • Save or load custom profiles for quickly repeating a search/replace in the future
  • Soporte y actualizaciones durante 1 año

Aprende más sobre Mejor búsqueda y sustitución Pro

La funcionalidad de búsqueda y sustitución está basada en la interconexion de su fantástico script de código abierto Search Replace DB, modificado para usar las funciones nativas de la base de datos de WordPress y así asegurar la compatibilidad.

Idiomas incluidos

  • Inglés
  • Francés
  • Alemán
  • Español

¿Quieres colaborar?

Feel free to open an issue or submit a pull request on GitHub.

Capturas

  • La página de Mejor búsqueda y sustitución añadida al menú "Herramientas"
  • Después de ejecutar un simulacro de búsqueda/sustitución.

Instalación

Install Better Search Replace like you would install any other WordPress plugin.

Dashboard Method:

  1. Login to your WordPress admin and go to Plugins -> Add New
  2. Escribe «Better Search Replace» en la barra de búsqueda y selecciona este plugin
  3. Click «Install», and then «Activate Plugin»

Upload Method:

  1. Unzip the plugin and upload the «better-search-replace» folder to your ‘wp-content/plugins’ directory
  2. Activate the plugin through the Plugins menu in WordPress

FAQ

Using Better Search Replace

Once activated, Better Search Replace will add a page under the «Tools» menu page in your WordPress admin.

Is my host supported?

Yes! This plugin should be compatible with any host.

Can I damage my site with this plugin?

Yes! Entering a wrong search or replace string could damage your database. Because of this, it is always adviseable to have a backup of your database before using this plugin.

How does this work on WordPress Multisite?

When running this plugin on a WordPress Multisite installation, it will only be loaded and visible for Network admins. Network admins can go to the dashboard of any subsite to run a search/replace on just the tables for that subsite, or go to the dashboard of the main/base site to run a search/replace on all tables.

How can I use this plugin when changing URLs?

If you’re moving your site from one server to another and changing the URL of your WordPress installation, the approach below allows you to do so easily without affecting the old site:

  1. Backup the database on your current site
  2. Instala la base de datos en tu nuevo host
  3. On the new host, define the new site URL in the wp-config.php file, as shown here
  4. Log in at your new admin URL and run Better Search Replace on the old site URL for the new site URL
  5. Delete the site_url constant you added to wp-config.php. You may also need to regenerate your .htaccess by going to Settings -> Permalinks and saving the settings.

More information on moving WordPress can be found here.

Reseñas

10 de febrero de 2024
Hace justo lo que se le pide sin complicaciones. Me ha sido de mucha utilidad, lo recomiendo 100%
25 de enero de 2024 1 respuesta
I feel misled as the 'dry run' option is NOT part of the free plugin but rather a paid option. Imho 'dry run' is essential in any search and replace plugin so advertising this plugin as 'free' is a bit misleading. Technically this plugin is free but unusable (way to dangerous/powerful) as such.
14 de diciembre de 2023 2 respuestas
I was going to try doing some search and replacements, and chose to do the 'dry run' first, but apparently you can't view the results from the dry run, without upgrading to the paid version. This effectively makes it less than useless. I'm not going to run a search/replace on a table unless I can preview what's going to be changed first.
24 de noviembre de 2023
This really make my life better. For real. Since I found this plugin al my migrations are FLAWLESS. So simple so good. Thanks a lot!!!
Leer todas las 509 reseñas

Colaboradores y desarrolladores

«Better Search Replace» es un software de código abierto. Las siguientes personas han colaborado con este plugin.

Colaboradores

«Better Search Replace» está traducido en 28 idiomas. Gracias a los traductores por sus contribuciones.

Traduce «Better Search Replace» a tu idioma.

¿Interesado en el desarrollo?

Revisa el código , echa un vistazo al repositorio SVN o suscríbete al registro de desarrollo por RSS.

Registro de cambios

1.4.5 – January 18, 2024

  • Security: Unserializing an object during search and replace operations now passes 'allowed_classes' => false to avoid instantiating the object and potentially running malicious code stored in the database (thanks to Wordfence for responsible disclosure on December 18, 2023 followed by development and testing of the fix by WP Engine)
  • Fix: A regression in version 1.4.4 which caused some search results to be skipped has been fixed to ensure only numeric keyed objects are skipped

1.4.4 – December 14, 2023

  • Fix: Objects with numerical properties are now skipped to avoid causing errors

1.4.3 – September 5, 2023

  • New: Links to plugin documentation, support, feedback, and changelog are now available in the footer of WP Admin
  • Improvement: PHP 8.2 and Better Search Replace are now compatible

1.4.2 – January 11, 2023

  • Security: Arbitrary tab templates in the templates directory can no longer be loaded using a query parameter.

1.4.1 – July 25, 2022

  • Security: Selected tables are now confirmed to exist before processing the request

1.4 – April 7, 2022

  • New: Better Search Replace has a brand new user interface
  • Improvement: Default capability required to use the plugin has changed from «install_plugins» to «manage_options» for compatibility with DISALLOW_FILE_MODS

1.3.4 – December 7, 2020

  • Improvement: WordPress 5.6 and PHP 8 compatible
  • Fix: Strings that have been serialized twice showing up as false-positives

1.3.3 – February 26, 2019

  • Fix: Some special characters interfering with search/replace
  • Security: Pass template filenames through sanitize_file_name()
  • Security: Verify nonce when downloading diagnostic info

1.3.2 – January 3, 2018

  • Fix: Only one table searched on some environments (props @Ov3rfly)
  • Tweak: Update text in sidebar

1.3.1 – September 14, 2017

  • Security: Check if data is serialized before unserializing it
  • Improvement: Increased size of table select

1.3 – November 10, 2016

  • Improvement: Updated sidebar and added pro version discount
  • Fix: Outdated links to old website
  • Fix: Prevent requests to invalid tabs

1.2.10 – June 2, 2016

  • Fix: CSS not loaded on details page

1.2.9 – December 8, 2015

  • Fix: Bug with case-insensitive searches in serialized objects
  • Fix: Bug with early skip due to lack of primary key

1.2.8 – November 25, 2015

  • Fix: Bug with report details

1.2.7 – November 24, 2015

  • Fix: Untranslateable string
  • Tweak: Check BSR_PATH instead of ABSPATH to be consistent
  • Tested with 4.4

1.2.6

  • Removed unused code/small cleanup

1.2.5

  • Improved progress bar info and styles
  • Small cleanup

1.2.4

  • Added «Settings saved» notice when saving settings
  • Fixed bug with wp_magic_quotes interfering with some search strings

1.2.3

  • Fixed bug with searching for backslashes
  • Fixed potential bug with getting tables in large multisites
  • Fixed potential notice in append_report
  • Improved handling of missing primary keys

1.2.2

  • Fixed AJAX conflict with WooCommerce
  • Fixed a few issues with translations
  • Cambio en «Información del Sistema» para usar get_locale() en vez de la constante WP_LANG
  • Updated German translation (props @Linus Ziegenhagen)

1.2.1

  • Fixed minor issue with display of progress bar
  • Updated translation file

1.2

  • Switched to AJAX bulk processing for search/replaces
  • Decreased minimum «Max Page Size» to 1000
  • Added «Help» tab with system info for easier troubleshooting

1.1.1

  • Added ability to change max page size
  • Decreased default page size to prevent white screen issue on some environments

1.1

  • Added ability to change capability required to use plugin
  • Small bugfixes and translation fixes

1.0.6

  • Added table sizes to the database table listing
  • Added French translation (props @Jean Philippe)

1.0.5

  • Added support for case-insensitive searches
  • Added German translation (props @Linus Ziegenhagen)

1.0.4

  • Potential security fixes

1.0.3

  • Fixed issue with searching for special characters like ‘\’
  • Fixed bug with replacing some objects

1.0.2

  • Fixed untranslateable strings on submit button and submenu page.

1.0.1

  • Fixed issue with loading translations and added Spanish translation (props Eduardo Larequi)
  • Fixed bug with reporting timing
  • Updated to use «Dry Run» as default
  • Added support for WordPress Multisite (see FAQs for more info)

1.0

  • Version inicial