Tables names changes to lower case during Export

I've noticed a problem with my table names after Export database as SQL. If my source has table names like "Clients", "PostalCodes", "Assets", etc and I use Export database as SQL to another database, they arrive as "clients","postalcodes","assets".

This makes my program unable to use the destination database because the table names are case-sensitive.

This is not done by HeidiSQL, it's the server. Windows MySQL does that by default, while Linux MySQL does not. See here for details.

Find out if your server does it:

SHOW VARIABLES LIKE 'lower_case_table_names'