Wednesday, May 10, 2017

How to change MySQL table names in Linux server to be case insensitive?

Edit the mysql configuration file
nano /etc/mysql/my.cnf
or any other my.cnf file which is used to configure your mysql.
Under 
[mysqld]
add the line 
lower_case_table_names=1
Run 
sudo service mysqld restart
You might want to reimport your windows database into your linux database. Preferably from scratch, with add table and insert statements.
It's good!

http://stackoverflow.com/questions/11165944/how-to-change-mysql-table-names-in-linux-server-to-be-case-insensitive

No comments: