Solving Mysql Mono port issues

courtesy

Checklist items to tick when porting ASP.NET MySql projects from .NET on Windows to Mono.NETon Ubuntu linux:

• Since Mysql is more case-sensitive on Linux, make sure that [Database=](http://stackoverflow.com/a/26457971/2404470) names matches with actual database names in connection strings. Better, keep them in lowercase.
• Make sure that MySql 5.6+ is installed since the default command [sudo apt-get install mysql-server](http://xameeramir.github.io/install-mysql-ubuntu-linux/) installs version 5.5
• The version of MySql on Ubuntu Linux and Windows shall match
• MySql v5.5 tables doesn’t support FULLTEXT indices and CURRENT_TIMESTAMP features, upgrade from it

Originally published at xameeramir.github.io.