Resources: Code

Case-sensitive MySQL tables on XAMPP

3 May 2013

Windows and Mac OSX aren't too bothered about the case in your MySQL databases, however Linux is. TableName is not the same as tablename (at least in Linux).

If you're working with Git, and are using it to manage your databases, you will need a seamless (and identical) setup between XAMPP and your production/dev environments. To make XAMPP respect cases, track down your my.ini file (usually C:/xampp/mysql/bin/my.ini) and add the line below (or update it if it already exists):

lower_case_table_names = 0

This will make XAMPP allow uppercase table names, which will mean you can safely push to a *nix environment!

Tags: , , ,

Let's work together