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
![](https://andjey.info/wp-content/uploads/2021/11/mysql-skip-innodb-read-only-compressed.png)
Save changes and restart mysql server:
sudo systemctl restart mysql