Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Export data lower-cases foreign key table names
SQLyog exports the “Create Table…” stmts. returned by the MySQL server. It does not modify anything before dumping it into the export file.
This is a known issue with MySQL.
=C=
Set lower_case_table_names variable to 1 in the MySql running on Linux. This forces MySql to create all tables (and since 4.0.4 all databases) lowercase.