How to fix Nextcloud 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE

If you have an error like:

InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE

All you need – to edit mysql configuration file: /etc/mysql/my.cfg

sudo nano /etc/mysql/my.cfg

Add this command:

skip-innodb-read-only-compressed

Save changes and restart mysql server:

sudo systemctl restart mysql