Home>Support>How to update the content via Database?

How to update the content via Database?

Hi!

I have around 200 posts are built with Page Builder, but I need to change one layout

"row_stretch":"(full)",
to
"row_stretch":"(full-stretched)",
in these 200 post.

I have tried to export the database and replace the string, but nothing changed after I updated the columns in database.

I wonder if the content save in the WordPress backend is the same one I found in database? Or is there anyway to update the layout in batch?

Thank you!
Atelier

This is our free support forum. Replies can take several days. If you need fast email support, please purchase a SiteOrigin Premium license.

  1. 7 years, 1 month ago Alex S
    Hi, I Work Here

    Hi Atelier,

    This is not something we recommend doing because if this is done incorrectly, it could easily break your page builder data.
    Your best bet to do this correctly would be to use a plugin that can handle serialized data – something like Better Search and Replace. Please note that we’re unable to assist you if this breaks your page builder data.

    Outside of this, this is beyond the scope of what we can help you with on our forums, but you could hire a developer to assist you with this.

    We recommend using Codeable. You’ll be able to hire someone at an hourly rate to do this work for you.

Replies on this thread are closed. Please create a new thread if you have a question, or purchase a SiteOrigin Premium license if you need one-on-one email support.

Get The Most Out of SiteOrigin with SiteOrigin Premium

Find Out More