[Opendnssec-user] upgrade debian Jessie to Stretch: database trouble

[Casper Gielen]

Op 02-11-17 om 16:00 schreef Dennis Baaten:
> Thanks for the info! This is helpful. Still getting the error when trying to
> load the new DB scheme (step 3). This probably is related to the fact that
> I'm having trouble to explicitly create a database using Barracuda with
> ROW_FORMAT=DYNAMIC.

That's done with innodb_large_prefix. Put the following in your config:

[mysqld]
innodb_large_prefix = on
innodb_file_format = Barracuda


PS. I'm on MariaDB, not MySQL, but you probably are as well so it
shouldn't matter.
-- 
Casper Gielen <cgielen at uvt.nl> | LIS UNIX
PGP fingerprint = 16BD 2C9F 8156 C242 F981  63B8 2214 083C F80E 4AF7

Universiteit van Tilburg | Postbus 90153, 5000 LE
Warandelaan 2 | Telefoon 013 466 4100 | G 236 | http://www.uvt.nl