Move OTS database from MySQL to MariaDB

If you installed MySQL 8.0 and imported OTS schema.sql with default settings, you database uses encoding not supported by MariaDB.

If you dump database using:

mysqldump dbname > dump.sql

and try to import it into MariaDB using:

mysql dbname < dump.sql

It will show error. To fix this, run these 2 commands:

sed -i 's/utf8mb4_0900_ai_ci/utf8_general_ci/g' dump.sql
sed -i 's/CHARSET=utf8mb4/CHARSET=utf8/g' dump.sql