Tables names changes to lower case during Export

User, date	Message
Written by mjordan552 3 years ago Category: Import/Export 1 posts since Wed, 25 Aug 10	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.
Written by ansgar 3 years ago 4026 posts since Fri, 07 Apr 06	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'
	Please login to leave a reply, or register at first. Username: Password: Remember me