Hello I am having the same problem with tables when i try to install a site from live to locally i get error messages saying that Table doesn’t exist for lots of tables.
I should also mention that when i packaged up from my live site using duplicator – i had to filter out my wordpress uploads folder as the site was too big to zip up. I am using 123-reg hosting.
I managed to get another much smaller site to go from local to live and live to local using duplicator no problem but this one was much smaller so i was able to package everything up as normal from the live site using duplicator.
I have tried a lot of options in the duplicator settings but same issue each time
any suggestions?