lower_case_table_names setting in Amazon RDS

Question

We have one Database instance in Amazon RDS with one DB. (By default its lower_case_table_names=0).

Now I have created another DB in same instance. For new site its giving table not found error because of case sensitive table name.

So I changed lower_case_table_names=1 (as 2 is not allowed) in RDS for that instance. New site started working but old site giving error tables not found.

Any solution? I would like to set lower_case_table_names=1 so issue will not appear for new DB's.

Thanks in advance!

Answer 1

I got the same issue, by default when you create a new MySQL instance using AWS RDS, it will use the default-parameter-group, the problem is you can't change any parameter in this default parameter group. To change the parameter value you have to create a new parameter group. Here how you do it:

1. On left panel go to Parameter Groups > Create Parameter Group > give name and description > Create > search for the parameter you want, in this case "lower_case_table_names" > Edit parameter, change it to 1> save.
2. On left panel go to Instances > in the content panel select Instance Action > Modify > Database Options > Database Parameter Group > Select the parameter group you want > Continue > reboot the instance > wait for few minutes then everything all set

Hope it helps :)