# Enabling MySQL 4-byte support --\> General error: 4047 InnoDB refuses to write tables with ROW\_FORMAT=COMPRESSED or KEY\_BLOCK\_SIZE

**URL:** <https://help.nextcloud.com/t/enabling-mysql-4-byte-support-general-error-4047-innodb-refuses-to-write-tables-with-row-format-compressed-or-key-block-size/120068>\
**Category:** ℹ️ Support\
**Created:** [July 12, 2021, 1:33pm UTC](https://help.nextcloud.com/t/enabling-mysql-4-byte-support-general-error-4047-innodb-refuses-to-write-tables-with-row-format-compressed-or-key-block-size/120068 "2021-07-12T13:33:15Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![j-ed](https://help.nextcloud.com/user_avatar/help.nextcloud.com/j-ed/32/7281_2.png) [@j-ed](https://help.nextcloud.com/u/j-ed)\
**Post date:** [July 14, 2021, 12:57pm UTC](https://help.nextcloud.com/t/enabling-mysql-4-byte-support-general-error-4047-innodb-refuses-to-write-tables-with-row-format-compressed-or-key-block-size/120068/2 "2021-07-14T12:57:54Z")

</div>

Please check the comments at the end of this thread which are related to the required InnoDB settings.

> [@New Setup Docker Compose not working](https://help.nextcloud.com/t/new-setup-docker-compose-not-working/115673/8):
>
> Please start with the [official](https://hub.docker.com/_/nextcloud) docker-compose file - this is doesn’t cover everything you want (e.g. no cron and redis) but it is good starting point… version: '2' volumes: nextcloud: db: services: db: image: mariadb restart: always command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW volumes: - db:/var/lib/mysql environment: - MYSQL\_ROOT\_PASSWORD= - MYSQL\_PASSWORD= - MYSQL\_DATABASE=nextcloud - MYSQL\_USER=nextcloud app:…

---

_[View the full topic](https://help.nextcloud.com/t/enabling-mysql-4-byte-support-general-error-4047-innodb-refuses-to-write-tables-with-row-format-compressed-or-key-block-size/120068)._