Solocoombe

Adding to my own thread incase anyone needs this info in the future.

Both solution above do not actually work, my original solution does not fully update everything. I managed to do what I needed to do by doing the following:

Go into wp-content/themes/your-theme-folder/functions.php.

Add this action and save:
update_option( ‘siteurl’, ‘https://example.com’ );
update_option( ‘home’, ‘https://example.com’ );

It will update nearly everything without the need for search & replace.

Go into the network database and make sure the following tables are updated with the new domain:
`wp_option
wp_site
wp_sitemeta
wp_blogs
wp_#_options

Then update the WP-config file with the new domain.

Now everything should work.

Hey, thanks for reply.

When running Multisite the URL options under the Admin > Setting do not appear. Atleast for me I didn’t have them.

Update: Solved my own question, actually very easy.
Once in phpMyAdmin, select your WordPress database and browse the table wp_options. Find the options siteurl and home and change their values to the new domain you want to use.

I have an update to the above. I have restored from a backup and the site has partially restored. The remaining problems is that there are no images appearing anywhere in the site at all and the link to the home page from any other pages does not work.
Does anyone know the simple answer to the 2 problems?
Thanks

@jonradio & songdogtech, great thanks for the advice will return to backup and start over, I take it I should change my data base/ wp-options back for the moment until I restart the process?
Thanks all for help.

The current site appearance does suggest there are no style sheets. In the source code viewed through the browser the style sheet path points to where the styles used to be located, not where they should be now.

Ok makes sense. Will I be able to get into my Admin? Because I made the setting updates in the dashboard before all went wrong.
Thanks