MySQL Row Size Too Large

azadhussnain

• March 19, 2021 07:12

Hello, myclients are facing an sql error Row Size Too Large while importing an sql file in phpmyadmin or via backup wizard. here is my /etc/my.cnf : [mysqld] performance-schema = 0 datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock symbolic-links = 0 log-error = /var/log/mysqld.log pid-file = /var/run/mysqld/mysqld.pid innodb_buffer_pool_size = 134217728 max_allowed_packet = 268435456 open_files_limit=80000 innodb_file_per_table = 1 innodb_log_file_size = 512M
please tell me how can i increase mysql roz file limit ? i am running mariadb 10.3 with mysql governor and cloudlinux. i read all forums and all threads but didn't found an accurate or an final solution. please tell me any final and accurate solution

• 

  andrew.n

  • March 19, 2021 14:00

  What is the exact error you are getting when you import the database?

  0
• 

  cPRex Jurassic Moderator

  • March 19, 2021 14:56

  As @andrew.n was hinting at, there are a few different "row size" errors, but I'm guessing you are running in to one of the two mentioned here:

  0
• 

  azadhussnain

  • April 16, 2021 06:30

  As @andrew.n was hinting at, there are a few different "row size" errors, but I'm guessing you are running in to one of the two mentioned here:

  0
• 

  cPAdminsMichael

  • April 16, 2021 10:42

  @cPRex is already linking to a page describing the issue and how to fix it :) Issue is probably that your client is moving from a database NOT running in strict mode, and yours ARE running in strict mode (default in later versions of MySQL/MaraDB)

  0
• 

  cPRex Jurassic Moderator

  • April 16, 2021 13:07

  @azadhussnain - there is not an easier fix available for the issues you are seeing. If that fix doesn't work, or if you are not able to apply it, you may want to speak with your hosting provider to see if they can check the server and get you more details.

  0

Please sign in to leave a comment.