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 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
Edit my.cnf inside the MySQL bin folder
then under the [mysqld] section paste below codes
Save the file the restart mysql server.
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.