How to fix mysql error #1118 - Row size too large?

T

Togzi2022-04-12 07:21:28

MySQL

Togzi, 2022-04-12 07:21:28

I'm trying to install a database from a backup to run the site on localhost. I get an error when importing. Please tell me how to fix it

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

R

Rsa97, 2022-04-12
@Togzi

RTFM

The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings.

T

Togzi, 2022-04-12
@Togzi

Changed the engine to MyISAM, the problem was solved