Starting on October 19, 2021, we will enable single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
To be prepared for this change and to avoid the need to register during your next ticket submission after the change, we encourage you to create an account here before October 19 using the same email address as your current Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account. You will continue to use ZenDesk authentication until we switch over to single-sign-on on October 19th.

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