Problem moving database from Windows to Unix
Permalink
Hello,
I develop on a windows box using mysql, and the schema that's created on a new install is all lower-case.
Now, I deploy to a unix box, where the schema that's created in a new install is all mixed case.
Now, while this seems crazy to me, I figure there's a good reason. The problem I'm having is that I can't move a backup of my dev site to live because of these case differences. C5 dies every time, with the "white-php-screen-of-death".
So, besides moving my dev env to unix, how can this be done? Can I instruct c5 to make sure all tables are lowercase when installing on unix?
Help!
Marcus
I develop on a windows box using mysql, and the schema that's created on a new install is all lower-case.
Now, I deploy to a unix box, where the schema that's created in a new install is all mixed case.
Now, while this seems crazy to me, I figure there's a good reason. The problem I'm having is that I can't move a backup of my dev site to live because of these case differences. C5 dies every time, with the "white-php-screen-of-death".
So, besides moving my dev env to unix, how can this be done? Can I instruct c5 to make sure all tables are lowercase when installing on unix?
Help!
Marcus
If you have problems with tables names after moving your site, check this 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
Peter
http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...
how it works:
http://www.concrete5.org/files/1112/9040/0018/MySQLCaseInsensitiveH...
Best regards
Peter
http://www.concrete5.org/community/forums/installation/move-site/#2...
and
http://www.concrete5.org/community/forums/installation/uncaught_exc...