MySQL database import in Plesk fails: ERROR 1118 (42000): Row size too large

Follow

Comments

2 comments

  • Avatar
    Mariusz B

    Hi!

    Thanks for posting this solution.  It helped me with installation of Zabbix on Raspberry Pi4 running MySQL / MariaDB.  Latest Raspbian / Debian 10 buster.

     

     

    0
    Comment actions Permalink
  • Avatar
    ABOLEON MEDIA (Edited )

    This did not solve it for me as I have upgraded MariaDB to 10.5.10 with default configuration file and changing as suggested leaded to mysql error because of uknown variable inno_db_strict_mode.

    However, I resolved my issue when I founded that it was caused by the ROW_FORMAT=COMPACT directive. Removing it from the import or changing it to

    ROW_FORMAT=DYNAMIC

    solves the problem.

    CREATE TABLE `table` (
    `id` int(10) UNSIGNED NOT NULL,
    ...
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request