After several attempts I found the solution. The best way to migrate a website from a local environment to live is through Akeeba Backups.
Please follow this guide if you encounter the same problem as mine:
https://www.joomshaper.com/blog/how-to-move-a-joomla-site-from-localhost-to-live-server
I think the real issue was about file and folders permissions, with Akeeba backups went everything went smoothly.
Use Akeeba Backup to Move the Joomla Site
To do this, you will be using the Akeeba Backup Joomla extension first to take a backup of your website (root files and database) and then Akeeba Kickstart to restore the backup to the live server. The transfer process consists of the following steps.
Step 1: Download and Install Akeeba Backup
First of all, you need to download the Akeeba Backup extension. Once you have downloaded the latest version in .zip format, login to your Joomla site administrator dashboard. From the dashboard, click on Extensions > Manage > Install. Here, under the Upload Package File option, browse and select the downloaded file. This will upload and install Akeeba Backup on your site.
Step 2: Backup Your Files
After the successful installation of Akeeba Backup, the next step is to take a backup of your site. Simply do this by: on top of the dashboard, select Components and then Akeeba Backup
Click Backup Now. This will download a .jpa file to your computer.
Step 3: Download Akeeba Kickstart
Download Akeeba Kickstart to your computer.
Step 4: Upload the Files to Your New Server
From your hosting control panel or FTP client, select the destination web root directory and upload the .jpa file from step 2 and kickstart.php from step 3 to the new server.
Step 5: Create a Database on Your Hosting Company’s Server
From your cPanel or server’s database management system, create a new empty database for your live site.
Step 6: Run the Kickstart Installer to Install Your Site on the New Server.
All you have to do now is from the browser go to (URL of your live site)/kickstart.php. You now need to follow the guide and install the website in live environment.