Local site redirecting me to live site

I just imported my site from a zip file. It seemed to work, but now when I launch the local site I am redirected to the live site. If I disconnect the internet connection I get a DNS error. Any ideas?

EDIT: Apparently I can access the local admin site, but not the frontend

You might try to open the Local’s site database (using Sequel Pro under macOS, don’t know how it works under Windows), and see what’s in the wp_options table. Look for “siteurl” and “home” option_name – does any of these point to the live site?

can you provide more detail instruction here on what we are looking for and what to change? I changed out the url and stuff from the database but my local site still goes to my live site. Please advise.