Ok, so I have dumped a MySQL 5.x database from an OS X instance, and am having problems importing the database into the OpenShift MySQL 5.5 container. My tables are Camel-case (eg "tblAccounts") but the script is throwing errors like "cannot find table tblaccounts".
I believe that MySQL's lower_case_table_names flag is set to 2 on OS X. And I was able to do a rhc set env command to change this variable from 0 to 2 on OpenShift. I keep getting the missing table error.
I have tried multiple combinations of this flag, and have tried to reload the db from scripts created using mysqldump and MySQL Workbench, and I haven't found a clean approach where this error does not appear. Am running out of ideas on how to do this cleanly. Any suggestions? Thanks,