Where to change the value of lower case table names 2 on windows xampp

Question

I am using windows 7 and xampp i am trying to export my database and while in the process the table names are converted to lower case  I have searched a lot  i know i have to change the value of lower case table names from 0 to 2 but where i have to change this value  in which file

User · Answer

If you have the file my-default ini rename it to my ini

User · Answer

ADD following -   look up for    The MySQL server  mysqld  add this right below it  lower case table names   1 In file -  etc mysql mysql conf d mysqld cnf   It s works for me

User · Answer

I have same problem while importing database from linux to Windows  It lowercases Database name aswell as Tables  name  Use following steps for same problem    Open c  xampp mysql bin my ini in editor  look for         The MySQL server       mysqld    3   Find      lower case table names   and change value to 2     if not avail copy this at the end of this  mysqld  portion      lower case table names   2     This will surely work

User · Answer

On linux I cannot set lower case table names to 2  it reverts to 0   but I can set it to 1    Before changing this setting  do a complete dump of all databases  and drop all databases  You won t be able to drop them after setting lower case table names to 1  because any uppercase characters in database or table names will prevent them from being referenced   Then set lower case table names to 1  restart MySQL  and re-load your data  which will convert everything to lowercase  including any subsequent queries made

User · Answer

Also works in Wampserver   Click on the Green Wampserver Icon  choose MySql  then my ini  This will allow you to open the my ini file  Then -   look up for    The MySQL server  mysqld  add this right below it  lower case table names   2 save the file and restart MySQL service   Important Note - add the lower case table names   2 statement NOT under the  mysql  statement  but under the  mysqld  statement  Reference - http   doc silverstripe org framework en installation windows-wamp

User · Answer

Try adding editing lower case table names   2 in my ini or my cnf

User · Answer

Do these steps    open your MySQL configuration file   drive  xampp mysql bin my ini look up for    The MySQL server  mysqld  add this right below it  lower case table names   2 save the file and restart MySQL service   From  http   webdev issimplified com 2010 03 02 mysql-on-windows-force-table-names-to-lowercase

User · Answer

Look for a file named my ini in your hard disk  in my system it s in  c  program files mysql mysql server 5 1   If it s not my ini it should be my cnf

[mysql] Where to change the value of lower_case_table_names=2 on windows xampp

Examples related to mysql

Examples related to xampp