Like everyone, I realized the case sensitivity issues in MySQL of late. I wanted to convert my upper case table names to lower case using this solution but I forgot to do Step 1 and completed the remaining steps. Now I couldnt access my tables that are in upper case. Renaming the tables using
mysql> rename table BOOK to book; ERROR 1017 (HY000): Can't find file: './las_data_3_dt2014/book.frm' (errno: 2)
Unable to use mysqldump on my database.
mysqldump: Got error: 1146: Table 'las_data_3_dt2014.adjustment_type' doesn't exist when using LOCK TABLES
I want to know if its okay to rename the upper case .FRM files to corresponding lower case files? So that I can run the rename commands and access the data again.