Search and Replace in Windows XAMPP site

you have the new database selected, then run some sql updates and replacement commands on the tables notably, wp_options, wp_posts, wp_postmeta.

UPDATE wp_options SET option_value = replace(option_value, 'https://livesite.com', 'http://localhost/sitename') WHERE option_name="home" OR option_name="siteurl";

UPDATE wp_posts SET guid = replace(guid, 'https://livesite.com','http://localhost/sitename');

UPDATE wp_posts SET post_content = replace(post_content, 'https://livesite.com', 'http://localhost/sitename');

UPDATE wp_postmeta SET meta_value = replace(meta_value, 'https://livesite.com', 'http://localhost/sitename');