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

Case Sensitivity Of Table Names Imported From .sql Script

forums forums SQLyog Using SQLyog Case Sensitivity Of Table Names Imported From .sql Script

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • #21988
      peterlaursen
      Participant

      The setting is in MySQL configuration itself. The configuration parameter is named “lower_case_table_names”

      Insert this line in the [mysqld] section your my.ini file

      lower_case_table_names=2

      ..and you will get the behaviour you want! You need to restart MySQL for the change to take effect.

      lower_case_table_names=0 means case-insensitive, store as lower-case (default on Windows)

      lower_case_table_names=1 means case-sensitive, store as mixed-case (default on most *nix – except Mac OS-X)

      lower_case_table_names=2 means case-insensitive, store as mixed-case

      However MySQL has confirmed a bug that I reported here:

      http://bugs.mysql.com/bug.php?id=20356

      (but it only affects the 'show create table' statement, not .sql import)

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