Building in Windows for deployment to Linux CPanel hosting - CamelCase confusion!!
Permalink
I love Concrete5, but I'm struggling to get a clear idea about how to address the case sensitive table names issues with a local Windows development environment.
To enable me to work efficiently with a site that I will eventually deploy to a Linux Cpanel hosted environment, I want to be able to use a WAMP style environment on my PC. I've come unstuck once with case sensitivty doing this and in the end was forced to rebuild a site from scratch directly on the Linux server.
I've seen a post about adding a "lower_case_table_names" parameter of 0 in MySQL in Wamp, but in the documentation for MySQL it advises against this (http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_lower_case_file_system) , and my understanding of MySQL is insufficient to evaluate whether the warning is relevant.
I'd really appreciate some informed guidance on creating a local development environment for Concrete5 on a Windows PC?
All the best
Andy
To enable me to work efficiently with a site that I will eventually deploy to a Linux Cpanel hosted environment, I want to be able to use a WAMP style environment on my PC. I've come unstuck once with case sensitivty doing this and in the end was forced to rebuild a site from scratch directly on the Linux server.
I've seen a post about adding a "lower_case_table_names" parameter of 0 in MySQL in Wamp, but in the documentation for MySQL it advises against this (http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_lower_case_file_system) , and my understanding of MySQL is insufficient to evaluate whether the warning is relevant.
I'd really appreciate some informed guidance on creating a local development environment for Concrete5 on a Windows PC?
All the best
Andy
I've seen the renaming script thread and the add on in the marketplace, but this feels more like a solution to a problem once you've ended up with lowercase table names.
I'd rather set up MySQL to recognize case sensitive table names. I suppose my question is whether the lower_case_table_names parameter change is a safe way of achieving this in a Windows environment?
In the MySQL online reference it says this:
You should not set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or Mac OS X). If you set this variable to 0 on such a system and access MyISAM tablenames using different lettercases, index corruption may result.
The problem with the rename script is that if you build a site locally and add various add ons, they will also suffer from the case sensitive issue. I found that despite the renaming script (I didn't try the add on) I still had problems and ended up recreating the site from scratch.
I'm just used to being able to quickly customise a site and style it locally using Wordpress and Drupal. I've been really taken with Concrete5's usability and the marketplace model for add ons, but the problems setting up a local development environment is for me a major issue.
So does anyone know enough about MySQL to advise whether it's safe to set lower_case_table_names to 0?
I'd rather set up MySQL to recognize case sensitive table names. I suppose my question is whether the lower_case_table_names parameter change is a safe way of achieving this in a Windows environment?
In the MySQL online reference it says this:
You should not set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or Mac OS X). If you set this variable to 0 on such a system and access MyISAM tablenames using different lettercases, index corruption may result.
The problem with the rename script is that if you build a site locally and add various add ons, they will also suffer from the case sensitive issue. I found that despite the renaming script (I didn't try the add on) I still had problems and ended up recreating the site from scratch.
I'm just used to being able to quickly customise a site and style it locally using Wordpress and Drupal. I've been really taken with Concrete5's usability and the marketplace model for add ons, but the problems setting up a local development environment is for me a major issue.
So does anyone know enough about MySQL to advise whether it's safe to set lower_case_table_names to 0?
We fixed this problem. Check our add-on:
http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...
how it works:
http://www.concrete5.org/files/1112/9040/0018/MySQLCaseInsensitiveH...
Best regards
Mixedpixel
http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...
how it works:
http://www.concrete5.org/files/1112/9040/0018/MySQLCaseInsensitiveH...
Best regards
Mixedpixel
There is also an add-on in he marketplace which I think helps manage this issue.
I've used the SQL script and it worked a treat.