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

Schema Sync – Unix To Windows – Table Case Problem

forums forums SQLyog Sync tools, Migration, Scheduled Backup and Notifications Schema Sync – Unix To Windows – Table Case Problem

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #13530
      Keith Davis
      Participant

      We are syncing from a Unix machine to Windows machines. The tables on the Unix server are not all lowercase. I’ve read various articles (http://faq.webyog.com/content/10/108/en/are-the-sqlyog-sync-tools-case-sensitive.html & https://mariadb.com/kb/en/mariadb/identifier-case-sensitivity/). The Unix server is also MariaDB if that makes a difference. On every Schema Sync, all tables are dropped and re-created:

       

      Is there something we can do to make this work?

       

      Would we have to disable this the “lower_case_table_names” setting?

    • #35710
      Kartik Grover
      Spectator

      Hi

       

      The MySQL documentation states the following in regards to hand;e case sensitivity: To avoid data transfer problems arising from lettercase of database or table names, you have two options:

      • Use lower_case_table_names=1 on all systems. The main disadvantage with this is that when you use SHOW TABLES or SHOW DATABASES, you do not see the names in their original lettercase.

      • Use lower_case_table_names=0 on Unix and lower_case_table_names=2 on Windows. This preserves the lettercase of database and table names. The disadvantage of this is that you must ensure that your statements always refer to your database and table names with the correct lettercase on Windows. If you transfer your statements to Unix, where lettercase is significant, they do not work if the lettercase is incorrect.

        Exception: If you are using InnoDB tables and you are trying to avoid these data transfer problems, you should set lower_case_table_names to 1 on all platforms to force names to be converted to lowercase.

      Please refer to this article for more details: http://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html

       

      Regards

       

    • #35711
      Keith Davis
      Participant

      Yikes, that sucks. If I had known that when I started building these systems, I would have turned it on for all of them. 

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