mysql error code 13 on windows xampp caused by lower case table names = 0

Posted by user127379 on Server Fault See other posts from Server Fault or by user127379
Published on 2012-11-25T10:52:15Z Indexed on 2012/11/25 11:06 UTC
Read the original article Hit count: 234

Filed under:

I can import an sql (from test linux server mysql) file if the lower case setting is removed. But then the table names are lower case and the web site doesn't work.

Originally it was working (my.ini with the lower case settings), I then exported to a linux server, it was working there. Now importing back to my windows (xampp setup) fails. After wild goose chase looking at disks and permissions, I found that if I remove the lower_case_table_names=0, the import works! But I need the case sensitive command so that I can deploy on the linux server.

© Server Fault or respective owner

Related posts about mysql