Usage

For using this add-on, install it before you move your site or its database. You can migrate the database in few different ways:

  1. Setup your local development environment's database server to case sensitive mode and run the migration
  2. Do a local backup of your database through the concrete5 backup functionality and migrate the backup files
  3. Download an SQL migration script and run it on the server where you're moving the site

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:

  • At the end of the of your MySQL server's configuration file (my.ini or my.cnf), add a line with "lower_case_table_names=0"
  • Restart the MySQL process
  • Go to the Database Migration tab
  • Click "Run Migration"

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:

  • Install the add-on
  • In your site.php, add line: define('DB_CASE_SENSITIVITY_FIX', true);
  • Load any page on your site
  • Remove the newly added line from site.php

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:

  • Go to the Database Migration tab
  • Click "Download Migration Script"
  • Move the script to your server and run it there

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

 

Where:

  • MYSQL_HOST = your MySQL server's address (e.g. localhost)
  • MYSQL_USER = your MySQL user name
  • MYSQL_DATABASE = your MySQL database name
  • MIGRATION_SCRIPT = the name of the downloaded migration script

After entering this command the console will still ask password for your MySQL user.