Update on Migrating to MySQL Enterprise Server documentation

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Answered
    • None
    • Component/s: Documentation
    • None

      This documentation: https://confluence.atlassian.com/display/FISHEYE/Migrating+to+MySQL+Enterprise+Server
      does not have information about case sensitive setting in MySQL: http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

      Migrating the MySQL database from one server to another server with mysqldump has cause the following error:

      * Select Smart Commits, check all options and click Apply
      
      An error occurred: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'fecru.AO_8219D4_COMMIT_HOOK_CONFIG' doesn't exist 
      
      * Select Web Hooks
          com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'fecru.AO_B434B9_WEB_HOOK' doesn't exist
          Table 'fecru.AO_B434B9_WEB_HOOK' doesn't exist
      

      The workaround is either setting case insensitive setting lower_case_table_names=2 in MySQL server or renaming the tables to lowercase manually.

      The documentation should have additional steps to check on the case sensitive setting in MySQL server.

            Assignee:
            Unassigned
            Reporter:
            Foong (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: