Migrate Foglight database from Windows to Linux (4258020)

The Foglight Management Server should be moved from a Windows to a Linux machine. The Foglight database is an external MySQL database. The database content has been exported and imported into the new database using mysqldump.

After starting up the Foglight Management Server the following error can be found in the log files:

2012-03-21 10:13:24.009 VERBOSE [main] com.quest.nitro.service.util.db.mysql.MySqlDatabaseAdapter - The database is using latin1_swedish_ci as the default character set collation.
2012-03-21 10:13:24.010 ERROR [main] com.quest.nitro.upgrade.db.validation.CharacterSetCollationValidation - The database is using a case-insensitive character set collation which is not supported.

Please do the steps below and reimport the exported data.

1. Drop the new database:
Mysql > DROP DATABASE foglight;

2. Recreate the Foglight database:
Mysql > CREATE DATABASE foglight;

3. Change the database collation and character set to UTF8
Mysql > ALTER DATABASE foglight COLLATE = utf8_bin;
Mysql > ALTER DATABASE foglight CHARACTER SET = utf8;