For using this add-on, install it before you move your site or its database. You can migrate the database in few different ways:
After installing the package you can find the functionality under System & Settings => Backup & Restore => Database Migration.
1. Setup your local development environment's database server to case sensitive mode
Here's how to do the first option:
If your site stopped working at this point, revert the MySQL configuration back and do the 2nd or 3rd option.
There's also functionality available that allows you to do the migration automatically during any page load. However, this should only be run ONCE. To do this, follow these steps:
If this does not work either, move to the 2nd or 3rd option.
2. Migrate the backup files
If you want to easily migrate the site backup files to have the corret database table names, just click the "Migrate Backup Files" link. Before you can do this, you need to have at least one backup file available at the Backup & Restore section.
After you've successfully migrated the backup files, you can just go back to the Backup & Restoresection and download the backup file you want to move to another server.
3. Download the SQL migration script
For an easy migration, just download the migration script from development server and run it on the server where you're moving the site to. To do this, follow these steps:
This is how you run the script on your server from console:
mysql -h MYSQL_HOST -u MYSQL_USER -p MYSQL_DATABASE < MIGRATION_SCRIPT.sql
After entering this command the console will still ask password for your MySQL user.