Hi,
We have some trouble with a site, so we want to copy it to a test location to start solving some of the issues.
But our biggest problem is the duplicator plugin not being able to handle the database size. so we had to manually move the site.
This worked kind of ok. with the search and replace tool to change the domain name in the db etc.
But all the pages 80 (8×10 languages) are now without pagebuilder content. The content itself is there, but the pagebuilds are gone.
And, clicking the pagebuilder, will just put all the page content in 1 pagebuild texteditor-block.
Were is this content/these settings stored? so I can read that table back and see if that works.
Revisions don’t seem to work… actually timeout the site.
I’m at a loss. Don’t know what to do about it.
Hope someone here can help.
Kind regards,
Martijn
Hi Martijn,
This worked kind of ok. with the search and replace tool to change the domain name in the db etc.
What tool did you use? To clarify, Page Builder data is stored in a serialized form so by doing that you may have broken the data. I would recommend using Velvet Blues Update URLs or Better Search and Replace to do search and replaces.
Regardless, Page Builder data is stored in the postmeta table with a meta_key of panels_data. Here’s an example SQL query to fetch all page builder data.
I used this tool.
https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
As suggested on the wordpress codex.
Were I only replaced livedomain.com for testdomain.com
Hi Martijn,
If I remember correctly, that tool does support serialized data but I’m not 100% certain. Maybe try undoing the previous search and replace to see if that restore Page Builder?
I’m doing that now. Will reload the post_meta table.
This worked, I see the proper layouts now.
Will use the better search and replace plugin after this.
I had to use external script before, as I couldn’t get into the admin.
Tnx for the help, will update if not working.