row size too large

How to fix Row size too large (> 8126).

Row size too large error is caused because of the MySQL configuration issues.
Row size too large (> 8126). Changing some columns to TEXT or BLOB may help.

Database power up a website with its content like text, images path etc. A mysql database contain all operations to be made by the website to load its content dynamically. As it contains very bulk operations inside it there may be chances for errors when working as a team.

Also read: How To Secure Apache with Lets Encrypt on Ubuntu 18.04

Similarly, when i try to import a database i received the error mentioned below. Most likely this error will appear in localhost only if your face this error in the server also you can use the solution below.

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

At first, i try to ALTER the database file using VS Code text editor but unfortunately it not worked. So after some research, i found a solution for the error above and it worked. So i choose to share the solution with friends.

Solution for localhost

Solution 1

Edit my.cnf inside the MySQL bin folder


then under the [mysqld] section paste below codes


Save the file the restart mysql server.

Solution 2

If you have no success with that. Then change innodb_buffer_pool_size to 32MB (default setting was 8 or 16) in my.ini (MySQL config file in XAMPP)


Hope this article helps you to fix the row size issue completely.

Follow TechBiriyani on FacebookTwitter to get all the latest updates.

Leave a Reply

Your email address will not be published. Required fields are marked *