Error with Replication of nextcloud database

ℹ️ Support
,
1

Hello there,

I installed nextcloud and mysql on a raspberry pi. The mysql database is working but not the replication. On the Slave machine, I get the Error 1071:

Error ‘Specified key was too long; max key length is 767 bytes’ on query. Default database: ‘nextcloud’. Query: ‘CREATE TABLE oc_migrations (app VARCHAR(255) NOT NULL, version VARCHAR(255) NOT NULL, PRIMARY KEY(app, version)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ENGINE = InnoDB ROW_FORMAT = compressed’

How can I fix this Error?

2

no one, who can help me? sad.

3

Read. Perhaps it is a solution. Use the command on your replication db.

[SOLVED] Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes