Hi,
I’m using Page Builder and Vantage Premium on a site that we recently migrated from our test environment to production, which involved swapping the test base URL for the production base URL.
I tried the following SQL updates, which I’ve used on other sites without Page Builder:
UPDATE wi_options SET option_value = replace(option_value, ‘http://75.103.85.184’, ‘http://www.womensinitiative.org’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
UPDATE wi_posts SET guid = replace(guid, ‘http://75.103.85.184′,’http://www.womensinitiative.org’);
UPDATE wi_posts SET post_content = replace(post_content, ‘http://75.103.85.184’, ‘http://www.womensinitiative.org’);
UPDATE wi_postmeta SET meta_value = replace(meta_value,’http://75.103.85.184′,’http://www.womensinitiative.org’);
The pages that used page builder lost their content, I’m guessing because Page Builder is using the GUID and my UPDATE’s don’t touch the Page Builder fields in the the right MySQL tables (judst a guess). Can you tell me how/where Page Builder is storing it’s content?
Thanks, Laura Peterson
Hi,
I figured this out on my own. The first 3 UPDATE queries are fine, but the 4th UPDATE will break Page Builder as it uses PHP serialization to save it’s data. You have use this tool to make the changes to the meta_value field in the postmeta table: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
This is a really fast, easy way to to a site migration if you are confident that the site URLs are all in the mysql.
Ciao, LP :-)
Hi Laura
Thanks very much for your posting your solution, I’m glad to hear you managed to resolve the issue.
Thanks a lot for the help, worked like a charm!
BTW, not for noobs, you can do serious damage if you don’t know what you are doing :)
Cheers!
Hi fgala
Glad to hear that helped.
For sure, search and replace is definitely an intermediate level task.
All the best :)