Solved – Restore Database ERROR 1118 (42000) Row size too large (> 8126)

Hari ini kami menemukan problem ketika melakukan restore database “ERROR 1118 (42000) at line 52: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.”

Solusinya bisa ditemukan disini : https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te

Server kami menggunakan mariadb 10.2 dengan menambahkan di /etc/my.conf.d/server.conf setting seperti ini

[mysqld]

innodb_log_file_size = 256M
innodb_strict_mode = 0

Jangan lupa di restart mariadb nya setelah melakukan perubahan.

Demikian, sekedar catatan admin.

Sharing is Caring.!

Leave a Reply

  Subscribe  
Notify of