It looks like your issue may be related to a lower_case_table_names` setting in your system:
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
It appears Windows systems set lower_case_table_names` to 1 by default, and Unix-based systems set it to 0. Based on the documentation above, try changing this value to 2 on your localhost (& restarting it). Here’s a link that has some instructions:
After you’ve changed your lower_case_table_names setting, the tables likely need updated on your localhost. I’ve attached an SQL snippet that when run should fix the case of your table names (for all the core tables, you will want to check & rename any tables from other modules).
After that, export from your localhost and check the SQL file. You should see the correct case for table names. From there you should be good to upload it to your webserver.