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
    • July 21, 2006 at 2:16 am #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)

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