Take a live wp site from the internet to localhost

PS, before anyone suggests “Duplicate” (https://premium.wpmudev.org/blog/guide-to-migrating-localhost-wordpress-to-live-site/), I realise that’s an option, now, but having spent all day copying the files and database down and configuring everything, and got the homepage etc running on localhost, I suspect I just need to change one hard coded value somewhere in one of the php files or something.

For a system that’s used as much as WP is, I’m always surprised at how long, if ever, replies to posts come.

Anyway, suffice to say I worked this out and for the benefit of anyone else who Googles as I did for “live wordpress site FROM the Internet TO Localhost”, the simple database tweak you need to do to your RESTORED database on your LOCALHOST (having of course copied your files to your Apache web root and having configured your MySQL system on localhost) is :

UPDATE wp_posts SET guid = replace( guid, ‘https://www.yourwebsite.com’, ‘https://localhost’ ) ;
UPDATE wp_posts SET post_content = replace( post_content, ‘https://www.yourwebsite.com’, ‘https://localhost’ ) ;
UPDATE wp_postmeta SET meta_value = replace( meta_value, ‘https://www.yourwebsite.com’, ‘https://localhost’ ) ;

After that, all is well. I can now take my live site offline, safe in the knowledge I have it running internally.

Or they could just follow these instructions

https://codex.www.ads-software.com/Moving_WordPress#Changing_Your_Domain_Name_and_URLs

Which accomplishes the same thing. ??