distal-attribute
distal-attribute
distal-attribute
distal-attribute

Tables names changes to lower case during Export

User, date Message
Written by mjordan552
4 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
4 years ago
4936 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.