Search and Replace in wp_posts

Beaver Builder
1

Hi,
I have a site with multiple pages constructed with BB plugin.

I have run a search and replace for a text string in the wp_posts table and can see that the content changed in the post_content field. However the content is the old string in the text editor field via Beaver plugin.

I deleted the cache but database shows correct and text editor incorrect.

Any other steps required?

2

Hi Neil,
BB pages are saved as serialized strings in wp_postmeta.

The simple content is also saved as post_content in wp_posts for enhanced compatibility (eg: Yoast Seo) and no lock-in policy, as you can disable BB at any time and retain your clean basic content.

A well working tool to search and replace also within serialized strings is
https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
a lot of people is using it with success for WP sites migration too.

Hope this helps!

3

You could also give this plugin a shot as it also updates serialized post-meta (you will still have to re-import the saved database tho) – https://wordpress.org/plugins/wp-migrate-db/

4

Hey Josh, I used that for a long time and it served me well too!

5

Thanks Alessandro - that did the trick

6

You’re welcome Neil, happy to help!