Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Export data lower-cases foreign key table names

forums forums SQLyog SQLyog: Bugs / Feature Requests Export data lower-cases foreign key table names

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #15228
      Ritesh
      Member

      SQLyog exports the “Create Table…” stmts. returned by the MySQL server. It does not modify anything before dumping it into the export file.

    • #15229
      CalEvans
      Member

      This is a known issue with MySQL.

      =C=

    • #15230
      Shadow
      Member

      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.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.