Database migration

Permalink
Hi,

My team has C5 version 8.2.1 running on a Windows server. We are looking to migrate our database from MySQL on that server to MySQL on a Centos server on our network.

After exporting the schema from the one server to the other we can't load pages. The error we are seeing is:

Error Code: 1146. Table 'www_asapchecks_com_v2_0.Packages' doesn't exist

We have determined that this is due to the way Windows and Centos handle case. On Windows, where the database was generated all db objects are named with lowercase. I haven't looked but the php queries are references tables (and probably other objects) in mixed case. Centos is case sensitive so our queries are failing.

I was wondering if anyone else have run into this and found a way around it?

Cheers,
Craig

 
ConcreteOwl replied on at Permalink Best Answer Reply
ConcreteOwl
There is a sql script on this page that you could try ...
https://www.concrete5.org/community/forums/installation/concrete5-8-...