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.
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
then under [mysqld] section paste below codes
Save the file the restart mysql server.
Hope this article helps you to fix the row size issue completely.