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 recieved the error mentioned below. Most likely this error will appear in localhost only if your face this error in 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

Edit my.cnf inside the mysql bin folder

C:/xampp/mysql/bin/my.conf

then under [mysqld] section paste below codes

innodb_log_file_size=512M
innodb_strict_mode=0

Save the file the restart mysql server.

Conclusion

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

Follow TechBiriyani on FacebookTwitter to get all the latest updates.

By Shahas Nizar

A passionate blogger and a tech enthusiast who is always keen and awaiting to know about fully fledged new technologies who's currently using iPhone 12 as a part of daily routine. You can spot me @ #facebook, #twitter & #Google +

Leave a Reply