dysfunctional XAMPP site transfer to live server: database malfunction

Hello Experts,

I am faced with a distinct problem with my server and have not found anyone with this same problem online. Could any of you have insights on what to do?

Here’s what happened:
1-I uploaded my entire WordPress website built on XAMPP (everything: content/database) to my host server (Astutium) manually through FTP using the steps listed here.

The site that I uploaded to my server is multilingual (using WPML.Org plugins), uses the Spacious Pro theme (that I customized), uses Beaver Builder plugin and has a blog.

2-Once all steps for a successful transfer from localhost to live server were completed, my database duplicated itself and generated empty duplicate tables with all CAP prefixes.

3-From that point, I was unable to access any of my content and I was left with a “empty shell” of a website (i.e. logged into WordPress Admin and only had plugins: there were no pages or posts. All content was missing).

4-I reached out to my host and they told me to provide them with the raw SQL data (from XAMPP database) in order for them to delete all the incorrect tables and “correctly conduct an import/merge”.

5-I provided my host with the raw SQL data and they deleted the empty database tables. However, after the removal of the duplicated tables, I still have no content on ANY of my pages. My host told me that my database content has been fixed but all I now see are page URLs with pages that have no content.
I then checked all my plugins to verify if they were all activated (they are) but I still have no content.

My questions to you are:

A-Do you know why the database tables duplicated during my transfer and generated all Cap prefix tables with empty content? My host was unable to explain this and it is very frustrating.

B-Do you have any insights how to get my pages/posts to show content ? What could be the problem?

Any insights to this problem are very appreciated.

Thank you