HAYWOOD Digital Tools

Hi Krystian, thanks for the quick answer. And it sounds good to me: paypal live works well on production. So after pushing staging I will double check if it still is connected and then resubscribe and simulate the webhooks on the connection tab as you said. Thanks a lot!

Thanks so much! That makes it a full circle. Will test it!

Would this be a possible solution:

First I export the setting from staging. Then I do transfer the complete options table from staging to production and then I import the settings from staging. That way my “not-so-propperly” transfered option table entries will be correctly overwritten by the imported settings.

Right?

Or should I better:

Export the settings from staging. Then delete the option table rows that include rank_math_ or rank-math- (I know tools that can do that). Then I tansfer the options table. And then I import the settings from staging. That way the non existing option table entries will be correctly written into the option table by the imported settings.

Would any of those 2 solutions work? Which one would be better?

ok. let′s summerize:

To push staging from live I can push all files and all tables except of the rows (columns?) in the wp_options table that start with either rank_math_ or rank-math-. Because those settings will only be rewritten to the options-table correctly if I re-import them as settings exported from staging.

Right?

But when I generally need my wp_options table to be transfered from staging to production, as many plugins save their settings into the wp_options table, how or with which tool/plugin should I exclude certain rows(columns) from a single table? The only tools I know for database migration can only exclude files, folders or certain tables, but not certain rows(columns) from within a certain table.

Thanks! How can I identify Rank Math options witin the wp_options table? Do they all have a prefix? Or can you name them if there aren′t too many?

Thanks for your reply. But I am confused now. Let′s Look into my questions and your answers:

1. As you can see here https://prnt.sc/8pjRZ9NfT-2F you DO have selective options on export of your settings. So which export settings are you refering to when you say you do not have selective options?
2. You did not really answer this question. So let me state it again: What should I exclude in the database transfer from staging to production that will better be covered by the export and then import settings process?

Just one followup question after reading the import export link:

As you suggested to use “the settings import instead”. Can you describe:

1. Which of the many export settings should I use on staging after finishing changes and how should I import them on the production site?
2. What should I exclude in the database transfer from staging to production that will better be covered by the export and then import settings process?

Thanks!

Truely excellent response! Thanks a lot!