-
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.