It does nor work for me =(
I copied the scrip and do not work, so I logged in in MariaDB and insert the command manually.
First, check the tables row_format
select table_name, row_format from information_schema.tables where table_schema = 'nextcloudDB';
+-----------------------------+------------+
| table_name | row_format |
+-----------------------------+------------+
| oc_ex_task_processing | Dynamic |
| oc_collres_resources | Compressed |
| oc_systemtag | Compressed |
...
| oc_ex_speech_to_text | Dynamic |
| oc_twofactor_backupcodes | Compressed |
| oc_ex_settings_forms | Dynamic |
| oc_preferences_ex | Dynamic |
...
Then i execute the command to alter the row_format
SELECT CONCAT('ALTER TABLE \`', TABLE_NAME, '\` ROW_FORMAT=DYNAMIC;') FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'nextcloudDB';
+----------------------------------------------------------------+
| CONCAT('ALTER TABLE \`', TABLE_NAME, '\` ROW_FORMAT=DYNAMIC;') |
+----------------------------------------------------------------+
| ALTER TABLE `oc_ex_task_processing` ROW_FORMAT=DYNAMIC; |
| ALTER TABLE `oc_collres_resources` ROW_FORMAT=DYNAMIC; |
| ALTER TABLE `oc_user_status` ROW_FORMAT=DYNAMIC; |
| ALTER TABLE `oc_flow_checks` ROW_FORMAT=DYNAMIC; |
| ALTER TABLE `oc_privacy_admins` ROW_FORMAT=DYNAMIC; |
| ALTER TABLE `oc_cards` ROW_FORMAT=DYNAMIC; |
...
But finally, if I check again the tipe, it do not change nothing
EDIT:
Also tried executing from console:
It ask password
sudo mysql -h localhost -uroot -p -e "SELECT CONCAT('ALTER TABLE \`', TABLE_NAME, '\` ROW_FORMAT=DYNAMIC;') FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'nextcloudDB';"