Resolving WSO2 API Manager DB Scripts throwing errors in MySQL 5.6

The error 1071 was giving by the below index creation SQL statement in the apimgt/mysql.sql. Which doesn’t allow to create a MySQL index with a table holding a column with VARCHAR(1024).

Fix for this issue with MySQL index is to compress row data of the above table while creating the table or by altering the table.

Since the DYNAMIC row format is only supported by the Barracuda file format, the following SQL statements should be executed before the running the apimgt/mysql.sql script.

These fixes in the MySQL 5.6 setup and the apimgt/mysql.sql script will help to resolve errors while setting up the databases for WSO2 API Manager 2.5.0 setup. :)

Related posts:

These are the most popular stories on LV Development this week. Discover how you can safeguard your wellbeing and build better relationships.

My rabbit brain just googled to find out when the next Leap Year will happen. Every four years, just like U.S. presidential elections, except on the centurial years. I’ll take the extra 24 hours in…

The idea of Bitcoin as “digital gold” has been wandering around in different blockchain-related media. The “gold” metaphor implies that Bitcoin should be seen as the most valuable store of value…