Database Migration

This Add-On helps you migrate your site's database from a Windows environment to Linux (case sensitive). You need this for example if you have developed your site under Windows with the default MySQL configuration with case insensitive table names. But if you want to migrate vice versa, you can also download that script and run it if you’d like. A little something for everyone (although a case insensitive environment will most likely turn your case sensitive tables to all lowercase automatically).

When do I need this?

You need this script if you're moving your site from a server that has used MySQL lower case table names to a server where you need case sensitive table names. For example if you're moving your site from a Windows development environment to Linux production environment, you might need this if you have not set the MySQL server's configuration correctly on the Windows development environment.

Get a database exception saying something like this:

mysql error: [1146: Table 'your_database.Packages' doesn't exist]

Then this Add-On might be just for you! This happens if you move your site from a case insensitive environment (e.g. Windows) to a case sensitive environment (e.g. Linux).

Usage

You can find the tools under System & Settings => Backup & Restore => Database Migration. For further instructions, please see the Documentation page.

This Add-On is officially made by Mainio Tech Ltd., for Concrete5 5.4.2 — 5.6.3.3.
This Add-On got ported, with exclusive permission from the above company's CEO (Antti Hukkanen), to Concrete5 5.7.x by Devoda.