Thanks for that, it does help clarify what happened.
Since the site is not popping back up in Local after reinstalling it, we’ll have to try to import the site into local. If you have the backup/export from your attempt to move the site to your hosting provider, the best bet may be to drag and drop that into Local to spin up a new copy of the site.
There’s a good chance that the reason your provider had trouble importing the SQL database is because of the collation that MySQL 8 uses by default. Check out this response from @clay in another post. It may be the key to getting your database to a state that you can import it.