migration wordpress to local machine does not work with all broken URLs except frontpage

Question

I installed XAMPP on my Win 10 PC and migrated my wordpress website onto my PC. After migration, only the frontpage works. The other URLs would get a "Not Found". The frontpage is only partially working but I see a page nevertheless.

I have change required data in wp_options. In wp_posts, I changed the URL in column guid. I have also tinkered with apache configurations but with no success. Setting debug to true in wp-config.php does not reveal anything unusual. May I know if you have any suggestions on what else I should tweak?

wp-admin works only if I do localhost/bs/wp-admin instead of localhost/wp-admin . I tried resaving the permalink but the links remain broken.

Thanks buttered_toast. The htaccess made the files visible. Is there another location where I need to change, I spot :

 
include(./php/depth2.php) file not found"

I use PHP Code Snippet (Otherwise known as XYZ PHP) plugin. I have marked up your answers. The themes seems to be defaulting to standard Avada themes.

Answer 1

When migrating a live site to local you need to do a couple of thing.

1. update the site url, you can do this in wp_options column (phpmyadmin) or in wp-config.php
2. You need to find and replace all instances of the old url, you can use better search replace, its a great plugin for exactly that
3. update the .htaccess to indicate the correct path of your wordpress

That should be enough for most cases

EDIT

Lets say that your wordpress site is located in htdocs/mysite

The RewriteBase and RewriteRule should be like this

RewriteBase /mysite/
RewriteRule . /mysite/index.php [L]