[Resolved] Changed url in database resets all views

[Author]

Posts

[Mr. DJ]

I am trying to:
Change the url of the test environment to the production environment like the query below. Or change protocol from http:// to https://

When i use this code, some url's still refer to the old url.

define('WP_HOME','<em><u>hidden link</u></em>');
define('WP_SITEURL','<em><u>hidden link</u></em>');

So i updated the database with this query.

UPDATE wp_options SET option_value = replace(option_value, '<em><u>hidden link</u></em>', '<em><u>hidden link</u></em>') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, '<em><u>hidden link</u></em>','<em><u>hidden link</u></em>');

UPDATE wp_posts SET post_content = replace(post_content, '<em><u>hidden link</u></em>', '<em><u>hidden link</u></em>');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'<em><u>hidden link</u></em>','<em><u>hidden link</u></em>');

Link to a page where the issue can be seen:
/

I expected to see:
No change in all the views.

Instead, I got:
All the view options are gone have to build every view from scratch, except the html and css.

[Noman Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)]

Hi,

Thank you for contacting Toolset support. The method you are using to migrate the site or changing url from test to live environment is not recommended.

I would highly recommend to move your site using one of the below trusted plugins:
- https://wordpress.org/plugins/duplicator/
- https://wordpress.org/plugins/updraftplus/
- https://wordpress.org/plugins/all-in-one-wp-migration/

Thank you

[Mr. DJ]

We use another tool to clone website's, i cant use this plugin to clone a wordpress website to a different server

[Noman Supporter Languages: English (English ) Timezone: Asia/Karachi (GMT+05:00)]

Other way to solve this issue is Export and Import Toolset data using our builtin option, this way you will have your Views working fine after migration. You can export and import Toolset data by going to Toolset >> Export / Import >>

There are multiple tabs at the top for each plugin (Types, Views, CRED, etc). You need to go to all tabs in Export/Import page and export import data for each plugin, please see attached screenshot.

Doc here: https://toolset.com/documentation/user-guides/how-to-importexport-types-structures/

So please follow this builtin method instead. Thank you

[Mr. DJ]

Thank you i will take a look at this.