Sorry for the lack of details. I’m new to databases and such.
I managed to fix the issue by duplicating what someone else did for me through a support channel which was deleting the duplicate wp2c_ tables and keeping the original wp_ tables.
Essentially my live site is working fine and I make a backup of it. I download the .zip backup file and attempt to import it with desktopserver.
After importing it through desktopserver, the address bar shows https://www.www.example.com and I get a error page.
I’ll provide more details next time.