How to make MySQL use capital letters when creating tables?

Hi Experts!

I'm facing a problem when migrating a MySQL database hosted at internet to my local machine.

First I obtained the backup script at host and then run it locally.

The local table names are created with lower case names even the script used it in capital letters.

Since I'd like to make the table names exactly the same to avoid problems between the 02 databases (I'm planning to develop sp(s) and get then returned to net)  how to workaround that?

01
Thanks in advance!
Eduardo FuerteDeveloper and AnalystAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Carl BohmanCommented:
Found this bit of documentation:

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Apparently, MySQL normally defaults to lower case and searches in a case-insensitive manner.

Are any of your tables mixed case or do you have any two tables with the same name but different case?  If not, you probably don't need to worry about the case of the tables.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eduardo FuerteDeveloper and AnalystAuthor Commented:
Hello

The way I wrote the script is all the same manner as in the picture.

But I realized that if using the same names from the net in the local DB (capital letters at table's names) no error occurs - the opposite isn't true.

Since the major worry is develop locally (with debug facility) and put at net then
it's a relief...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.