Migrating to LAMP

Permalink
All,
Greetings.
We have developed a site on c5 . The site works fine on windows with xampp.
However, something curious happens once we move to LAMP .
Site appears to work fine at first glance. However, clicking on any page for editing through admin dashboard errors out with controller not found error.
For Moving to LAMP - we followed the steps listed below :
1. Copy entire c5 folder (with application themes etc.) to appropriate web server dir.
2. Restore MySQL db backed from windows on to Linux on a freshly created empty db.
3. Set lower_case_table_names in MySQL config before restoring db.
Are we missing something ?
Please advise.
Thanks,
Mahesh.

 
JohntheFish replied on at Permalink Reply
JohntheFish
The problem with WAMP to LAMP is nearly always something to do with table name case. You appear to be trying to resolve that back to front to the usual practice.

The usual practice is to keep LAMP as mixed case table names. But when you set up your WAMP development system, configure MySQL for mixed case names there (because WAMP defaults to lowercase/couldn't care)

That way, your LAMP production environment is standard and you adapt your WAMP development environment to prepare for a move to standard LAMP.

There are some addons for converting database table names to mixed case and also some SQL scripts you can find on the forums.