Current MariaDB version does not allow to load dumps.
When using >=mariadb:5.9.4
, restoring any dump leads to the error:
ERROR 1074 (42000) at line 1101: Column length too big for column 'data' (max = 16383); use BLOB or TEXT instead
Problem seems to be the line CREATE DEFINER=
caosdb@
%FUNCTION
makeStmt(sourceSet VARCHAR(255), targetSet VARCHAR(255), data VARCHAR(20000)
, namely the length of the data
parameter.
Solution
The problem is a misconfigured database and only occurs when the database is created "by hand" and not with our standard scripts. Create your database with CREATE DATABASE <name> CHARACTER SET utf8 COLLATE utf8_general_ci
everything should be find.