Nextcloud version: 15.0.14
Operating system and version: Debian 9
Apache or nginx version Apache 2.4.25
PHP version 7.0.33
DB version: mariadb-server-10.1 (10.1.37)
Hi Support,
i’m starting to upgrading NC from 15.0.14 to the latest stable version.
In the last upgrade stage, NC let me to add support for 4 byte in MySQL.
My actual innodb_file_format is set as ‘Antelope’ .
Is not clear for my if I must run:
mysql> SET GLOBAL innodb_file_format=Barracuda;
or if follow literally each point of the MariaDB 10.2 or earlier doc, leaving out the above command.
If you want to have it as default - yes.
Which means every new table will be Barracuda - file format AND:
you have to change every old table that should have the new file format!
No - I read it again and it says in the note at the beginning: On some shared hosts, you may not have the permissions to upgrade the InnoDB file format, meaning you are unable to use utf8mb4
So you have to upgrade (MariadDB) if you want to upgrade (Nextcloud).