Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in AWS by (19.1k points)

I imported my MySQL database tables to Amazon RDS. My problem is that my queries don't longer work and I get an error that my table 'Folders' doesn't exist. The reason for that is that the table names are not all with the lower casing, which causes the query to throw this error.

Is there a way to change the table name with one with uppercase using MySQL Workbench against Amazon RDS database. I tried using 'alter table', but it gives me an error "Selected name conflicts with exists table' when I try to rename to the same name and changing to a capital letter. Any ideas on how to solve this?

Maybe there is an option to tell Amazon RDS to ignore table name and table field's capitalization.

1 Answer

0 votes
by (44.4k points)

Restart mysql after modifying your my.ini of MySQL and also change the lower_case_table_names.

lower_case_table_names=1 

  • Value ‘1’ is used on Amazon RDS Parameter Group.
  • Use value ‘2’ on a regular MySQL installation

Related questions

Want to get 50% Hike on your Salary?

Learn how we helped 50,000+ professionals like you !

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Browse Categories

...