Search and Replace Database Breaking Beaver Builder

Beaver Builder
1

I am trying to update a text string thoughout my site with the “Better Search and Replace” plugin as recommended. When I do that I keep getting an error. It says to reduce the Max Page size, but I’ve reduced it down to the minimum available option of 2000.

I tried doing a manual search and replace using phpMyAdmin, but that breaks the Beaver Builder formatting. The post content is still there, but it is unformatted by Beaver Builder as if it was built in the text editor. From what I understand, post content is stored in the wp_posts table whereas Beaver Builder Information is store in the wp_postmeta table. Manually searching and replacing wp_posts does not break the site, but it does not fix the appearance of Beaver Builder posts. When I search and replace the wp_postmeta table, the beaver builder content disappears.

So the questions are:

  1. Why will the Better Search and Replace Plugin not work?

  2. Why does my manual search/replace of wp_postmeta break the Beaver Builder structure?

  3. Is there another alternative I can use?

2

wordpress saves arrays and objects as serialised data. You cannot edit serialised data unless you unserialise it 1st, and serialise it again after.

3

Used interconnect/it and it seems to work OK. I have to run a few tables at a time to avoid timeout… which is what I think is happening with the search and replace plugin.