How to convert Nextcloud MariaDB/MySQL tables to ROW_FORMAT=Dynamic

In order to convert all tables in a MariaDB/MySQL database to use the ROW_FORMAT=DYNAMIC first set the default row format using the following SQL query:

SET GLOBAL innodb_default_row_format=DYNAMIC;

After that, generate the queries to convert all tables to use the ROW_FORMAT=DYNAMIC:

SELECT CONCAT('ALTER TABLE `', table_name, '` ROW_FORMAT=DYNAMIC;') AS sql_statements
FROM information_schema.tables
WHERE table_schema = 'nextcloud'
AND ROW_FORMAT != 'Dynamic';

Copy the output of the query and run it in your database. This may take a while depending on the size of your database.